Importing CSV with double quotes

cebu1014
cebu1014 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Anuradha GoliSystems Development / Support Specialist

Commented:
in What software you are trying to import

Author

Commented:
It goes into a old program that runs off of pervasive data engine.
Software Developer
Commented:
What tool are you using to do the import?  You might try having double double quotes:

ALUMINUM TRIM NAILS                1.25''"  8633

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial