none
How to split a column into multiple columns RRS feed

  • Question

  • Hello All,

    How can I split a column into multiple columns and insert/update another table? My data is delimited with a '|'. The data looks like this.

    column name 1|column value 1|column name 2|column value 2

    Eg: Service|service Name|Transaction|Transaction Name

    Most of the times column value 2 is also delimitted by | .

    I'm not sure how to accomplish this. Any guidance is welcome.

    Thanks in advance

    Wednesday, February 13, 2013 2:01 PM

Answers

All replies