Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help! Remove Quotation Marks in CSV 1

Status
Not open for further replies.
Nov 12, 2003
6
US
Hi! I'm a new Mercator user and I'm using a comma-delimited file with quotation marks for each field in the input file:

"ALFKI","Alfreds Futterkiste","Maria Anders"

But when I get the field values, the quotation marks become part of the output field. I need to get rid of those quotes because they're being passed on as part of the field values.

Any ideas?

Thanks!
 
You can either specify the " as an initiator and terminator for the data items in the type tree or use the substitute function in a map rule
 
Thanks for the quick reply. I did try using the Substitute function before but not sure what release character to use for the double-quote and how to represent a null substitute:

=SUBSTITUTE(CompanyName Field:Customers,""","")

This is giving me a parameter expected error..
 
what you need is
=substitute(OKItem Items:OKRecord Record [1]:testout,"""","")

record 1 contained test"
record 2 contained test after the substitute
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top