Saving to a text file

Highlighted
Five Stars

Saving to a text file

Hello 

 

Newbie here with a simple question .. When I use tfileoutputdelimited and save to a txt file it appears to save as one big paragraph yet when I save to a xls file the rows save separately 

 

the job is tfileinput to tsortrow to tlogrow to tfileoutput excel and tfileoutputdelimited 

 

saves great to the xls file but not to the the txt file  

 

Tom


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: Saving to a text file

I suppose you have checked your txt file with the standard Notepad which expect "\r\n" to separate lines and you have a single "\n".
Replace the line separator for the tFileOutputDelimited component to solve your case.
You may also check the file using Notepad++. You will see that everything is as expected.

TRF

View solution in original post


All Replies
Highlighted
Sixteen Stars
Sixteen Stars

Re: Saving to a text file

I suppose you have checked your txt file with the standard Notepad which expect "\r\n" to separate lines and you have a single "\n".
Replace the line separator for the tFileOutputDelimited component to solve your case.
You may also check the file using Notepad++. You will see that everything is as expected.

TRF

View solution in original post

Highlighted
Five Stars

Re: Saving to a text file

dang I love this support group Smiley Happy

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads