I have the following workflow:
tFileInputDelimited -> tmap -> databaseOutput
The program that created the csv file (and will do so daily) is adding quotes to the strings and dates, however, I need to remove these quotes prior to it being sent to tmap. How can I do this?
Solved! Go to Solution.
When you say yourfield, what does this represent? The quotes show up in several places in the row, but not always the same place.
Thanks cterenzi. I hadn't considered selecting csv options for my tab delimited file to get rid of the double quotes universally throughout the tfileinputdelimited. Solved a lot of ad hoc changes I was making later on.