Convert semicolon delimited text (;) to excel file from a CSV file

Help Activities
, ,
6

Hi @Ionut_Frincu,

You can use Generate Data Table from Text File activity to solve your issue.
Read the text file using Read Text File activity and pass that value as input to the Generate Data Table.

Use Column Separator as semicolon & NewLine Separator as newline
Pass in the text file as Input and the output will be a Datatable and pass that value to the Write CSV.

image
image888×631 60.8 KB

If you want the first row as Column Header, then Enable First Row as Column Headers

Regards,
@90s_Developer