Escape char in tFileInputDelimited adding Tab (\t) after every escape character.

tYrannoSaurusRex_1 — Sat, 16 Nov 2024 00:03:21 GMT

Hello,

I am working on a data coming from simple .csv file using tFileInputDelimited. Basic structure is as below,

Delimiter: Tab (\t)

CSV encoded with double quotes.

I set the CSV Options in tFileInputDelimited as below,

But every time I get same issue with columns having double quotes in body of any column.

I catch the error records in a reject file and it shows that in Float column next to it, string values are being pushed.

The Reject records look like these,

See in the screenshot, in Column3, whenever it hits a double quote, it adds a tab to it. Tab is the delimiter.

Thus it is somehow changing position of the column and creating multiple columns even though there isn't even a space after 2nd double quote.

Re: Escape char in tFileInputDelimited adding Tab (\t) after every escape character.

Anonymous — Thu, 17 Jun 2021 09:27:33 GMT

What is the escape char in your CSV file? if the column body contains double quotes, there should exist escape char such as:

"1" "shong"

"2" "XCFDGHJ\"A\"updated"

In this example, Tab (\t) is delimiter, "\\" is escape char.

Output will be:

Regards

Shong