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
Highlighted
Forteen Stars TRF
Forteen 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
Highlighted
Forteen Stars TRF
Forteen 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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.