| splitting and associating part of a field [message #38640] |
Thu, 02 May 2002 14:05  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
I have a column: col1
The data looks like this: '1=joe,2=some_host,3=someip'
I am trying to separate these values and insert them into their own columns. The twist is that the numbers: 1,2,3 are associated with values in another table. I use the other table to hold column names and a fictitional column id. If substr of val1 (obviously delimited by '=') is equal to 1 then insert it into column a, and so on...I have the first step complete, which is splitting the data and putting it into variables, but I don't am stuck, and am unsure how to perform the association with the new values 1=joe to this other table. My head is spinning so I apologize if I am not making sense.
Somebody please throw me a bone.
Thanks.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
