cebu1014
asked on
Importing CSV with double quotes
I want to import a description field with double quotes from a csv into our software. The import works but double quotes in a description are ignored and everything afterwards in that field. How would I lay out the field in order to get desired result?
Descr Field 1 Descr Field2
ALUMINUM TRIM NAILS 1.25'' 8633
Result
Descr Field 1 Descr Field2
ALUMINUM TRIM NAILS 1.25
Descr Field 1 Descr Field2
ALUMINUM TRIM NAILS 1.25'' 8633
Result
Descr Field 1 Descr Field2
ALUMINUM TRIM NAILS 1.25
in What software you are trying to import
ASKER
It goes into a old program that runs off of pervasive data engine.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.