Txt output without quotation marks

[Gloria_Loaisiga]

Hi all,

After running my workflow that creates a txt file, it put a quotation mark at the beginning of some lines, not in all lines nor all txt files.

How can I fix this issue?

Thanks in advance!

[NexBK]

Try operating Option 5 (Quote Output Fields) in Output Data.

[Gloria_Loaisiga]

Hi NexBK,

Thanks for replaying. I tried with your solution, however, the error persists! It's weird because some of the files are created with no issues but some of them contain those quotation marks at the beginning and end of the line.

[caltang]

You could still call all your data in and then use a Multi-Field formula tool to replace all ‘“‘ with ‘’. Make sure to select ALL fields and write your expression down there - something like:
REPLACE(ToString([_CurrentFields),’”’,’’)

You can select the current fields option by expanding on the options in the expression below.

Then you can use Text to columns to split it to their relevant columns. Or if you’ve already split it at the input level then just go on with your ETL.