How to split a string into tokens
446249Oct 12 2006 — edited Oct 12 2006Hi. This is a follow-up to a question from yesterday. I've got a string passed to the database that looks like this,
|12345^4.000|45678^3.670|.... -- more records
I'd like to loop over the string and be able to pick up each "record" and insert into a table. A record would be ID 12345 and value 4.000. Another record would be ID 45678 and value 3.670. How can I accomplish this? Your help is very much appreciated. Thank you.