[resolved] Problem load data into tFileOutputDelimited

[Anonymous]

Hi,

I'm load data from mssql to tFileOutputDelimited. After checking data in .txt. The output as below :




Certain data on COLUMN5 down to bottom line. How to solve this problem? why it is happen?

[Anonymous]

Hi,
We cannot repro this issue on V 6.2.1.
How did you set "Row Separator" on tfileoutputdelimited component?
Best regards
Sabrina

[Anonymous]

Row separator : "\r"+"\n"
Any suggestion.
Thanks.

[vapukov · Accepted solution]

it normally work fine, as You can see from picture - some of rows correct, other look like additional row separator inserted
You can test - manually clean COLUMN4 and COLUMN5 in tMap, rowXX.COLUMN4.replaceAll("[^a-zA-Z ]") and rowXX.COLUMN5.replaceAll("[^0-9]") (You can change regex) - it just to be sure - no hidden symbols in data