Delimited Text File Help

[coboldave]

I have a query that the results are exported out to a comma delimited file for importing into another application.

My problem is that a char field is used for product information where the user may enter a measurement in inches and using a double quote ' " ' after the number. This is of course being construed as being a delimiter and bombing my application.

How can I strip those from the field before creating the file.

Any help greatly appreciated.

Dave

 

[jbenson001]

How are you exporting the data? Are you using the Import/Export wizard in EM? If so, you can change the text qualifier to NONE.

Jim

 

[vbkris]

or:
--> enclose all ur values with "
--> replace all " in ur values with a ""

but i really cannot say anything without knowing how u export the data like Jim said...

Known is handfull, Unknown is worldfull