Saving to a text file

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
Sixteen Stars TRF
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
Sixteen Stars TRF
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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch 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