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
Fifteen Stars TRF
Fifteen 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

All Replies
Fifteen Stars TRF
Fifteen 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
Five Stars

Re: Saving to a text file

dang I love this support group Smiley Happy

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

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

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

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch