hello there! i'm new here. :) no on to my question.
i've searched the board but couldn't find anything in reference to my problem. i have several existing csv files. i got one to show up using dbman, but there were some fields that had commas in the body.
i.e., my line would look like this:
"blah blah, blah. blah blah, and stuff."
dbman would read the " 's instead of noticing them as enclosures and then drop the 'blah. blah blah' to the next field and the 'and stuff' to yet another one.
any help on this would be appreciated. if i convert all of my inner commas to ~~ like dbman does, then it won't display the way i am currently displaying. plus, well, i have a lot of csv files that i'd be changing by hand.
thanks. :)
i've searched the board but couldn't find anything in reference to my problem. i have several existing csv files. i got one to show up using dbman, but there were some fields that had commas in the body.
i.e., my line would look like this:
"blah blah, blah. blah blah, and stuff."
dbman would read the " 's instead of noticing them as enclosures and then drop the 'blah. blah blah' to the next field and the 'and stuff' to yet another one.
any help on this would be appreciated. if i convert all of my inner commas to ~~ like dbman does, then it won't display the way i am currently displaying. plus, well, i have a lot of csv files that i'd be changing by hand.
thanks. :)