Parsing pipe delimited string into columns?
Posted
by DMS
on Stack Overflow
See other posts from Stack Overflow
or by DMS
Published on 2010-05-31T07:38:22Z
Indexed on
2010/05/31
7:42 UTC
Read the original article
Hit count: 274
Hello, I have a column with pipe separated values such as:
'23|12.1| 450|30|9|78|82.5|92.1|120|185|52|11'
I want to parse this column to fill a table with 12 corresponding columns: month1, month2, month3...month12.
So month1 will have the value 23, month2 the value 12.1 etc...
Is there a way to parse it by a loop or delimeter instead of having to separate one value at a time using substr?
Thanks.
© Stack Overflow or respective owner
