Help! Remove Quotation Marks in CSV 1

[leonracsis]

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!

 

[janhes]

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

 

[leonracsis]

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,""","&quot

This is giving me a parameter expected error..

 

[janhes]

what you need is
=substitute(OKItem Items:OKRecord Record [1]:testout,"""","&quot

record 1 contained test"
record 2 contained test after the substitute