Hi,
We want to open this file in notepad++ by default and replace " with blank and save it in .csv format.
test.txt (91.7 KB)
Hi,
Please try the below steps:
- Read the Text file using the “Read text file” activity.
- In Assign Activity, Replace the “~~” to “,”
- Use Generate Datatable activity in which pass the output of step 2 as Input and
- Write the Output datatable of Step 3 to a csv file.