Thread

1. need help separating a field

   Kevin Heflin <kheflin@shreve.net> — 1999-02-11T20:46:19Z

   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@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
   --------------------------------------------------------------------
   
   
   

2. Re: [GENERAL] need help separating a field

   Ross Reedstrom <reedstrm@rice.edu> — 1999-02-11T21:05:21Z

   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@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
   > --------------------------------------------------------------------
   
   -- 
   Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
   NSBRI Research Scientist/Programmer
   Computer and Information Technology Institute
   Rice University, 6100 S. Main St.,  Houston, TX 77005