开发者

reading into table: comma values and quotes SQL

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=  开发者_运维技巧"something1"
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!


You should be able to use single quotes within $something to cause Access to treat the entirety of the quoted section as an atomic unit:

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


Replace the character sequence , " with something the pipe sign for example and then use that as field separator.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜