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
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.
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.
