Re: [GENERAL] need help separating a field

Well, I once split up a bunch of multiline addresses with lines like
this:

select "PerIndex",substr("addr",1,(strpos("addr",'\n')- 1)) as addr,
substr("addr",(str
pos("addr",'\n')+1)) as addr2 into tmp2_addr from tmp_addr;

so, try something like (untested):

select substr(username_password,1,(strpos(username_password,'/')-1)) as
username, substr(username_password,(strpos(username_password,'/')+1)) as
password into new_table from table;

Kevin Heflin wrote:
>
> I have a table with a field of 'username_password' where the data is in
> the format of:
>
> username/password
>
> what I would really like to do, is create a new field of 'username' and
> another of 'password' and with some magic SQL statement select all from
> username_password, and spit up the pair, and insert them back into the
> newly created 'username' and 'password' fields.
>
> Is this even possible? and if so, would anyone be willing to give me a
> hint?
>
> Kevin
>
> --------------------------------------------------------------------
> Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
> VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
> kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
> --------------------------------------------------------------------

--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005