reading into table: comma values and quotes SQL

Posted by every_answer_gets_a_point on Stack Overflow See other posts from Stack Overflow or by every_answer_gets_a_point
Published on 2010-06-03T17:02:45Z Indexed on 2010/06/03 17:04 UTC
Read the original article Hit count: 143

Filed under:
|
|
|

i have a string like this

something = "something, something1, "something2, something else", something3"

i need it to be read into a table like this:

field1 = "something"
field2=  "something2"
field3 = "something2, something else"
field4 = "something3"

please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field

anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql.

thanks!

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql