Text to csv

[hanviprebday]

Hi all,
I want to convert a text file to csv file how to go with that.

Please help me.

Thanks in advance

[Shiva_Nikhil]

@hanviprebday

read text file activity

Generate datatable activity

write csv activity

[Gokul001 (Gokul Balaji)]

Hi @hanviprebday

Check out this video

UiPath | Convert Text File to CSV File | Get Data from Text File into CSV File | Create CSV File

How to Convert .txt file data to CSV /xlsx?

HI @smanik19 we have an activity called generate datatable activity , where we can pass the text, a string variable as input and get the output as datatable which can be written to a excel with write range activity for more info on generate datatable activity https://activities.uipath.com/docs/generate-data-table Cheers @smanik19

Regards

[Tapan_Behera1 (Tapan Behera)]

Hi @hanviprebday use generate data table activity

[Unnathi_Bhat]

Method 1:
Step 1:Use Read CSV Activity where in_TextFilepath is the text file path output is in the datatable type

Step 2:Use Write CSV activity

Where dt_DataToConvertCsv is the output from step 1 and In_CSVFilePath will be csv file with path with .csv extention

Method 2:

Step1: Use read Text file activity and store the output in a string variable

Step 2:use Generate data table from text activity and enable CSV parsing in formatting options in properties panel and store the output in a datatable type variable

Where Str_TxtOutput is the string output from step1

Optional(only if column separator is not comma):Click on options present in the activity and add the column separator in the below window (You can also test some text data if required)

Step 3:Use Write CSV activity

Where dt_DataToConvertCsv is the output from step 2 and In_CSVFilePath will be the file path with .csv extention

[hanviprebday]

Thank you all I got it