Read data from txt and write it to an excel file

[teslyak9437 (Sam)]

Hello!!!
I have a txt file from which I need to read data and write it to an excel file. There are several lines in the txt file that need to be written in each separate line. What is the best way to implement this in StudioX?
TEXT1.txt (848 Байти)

[ppr (Peter Preuss)]

we can cleanse the text to have a more reliable value delimiter and the treat it as CSV data, which can be parsed into a DataTable by using the generate DataTable Activity

UPD1 - StudioX variations

• Cleanse
• Save to Text File
• read Cleansed TextFile with Read CSV File Activity

[lrtetala (Lakshman Reddy)]

Hi @teslyak9437

Try with Generate Data Table from Text activity

NewBlankTask6.zip (255.4 KB)

Regards,

[teslyak9437 (Sam)]

it mast Look

[lrtetala (Lakshman Reddy)]

@teslyak9437

Try this

Output: