Open csv file as in notepad and edit it and then save it as text file

[Pushkal (Pushkal. B)]

hey guys,
how to open a selected CSV file in notepad for further edits, changes,
then save it as a text file.

[postwick (Paul)]

That’s not how you should edit a CSV. You should read it into a datatable, update the data in the datatable, then write it back out to CSV.

[Karan_Zaveri]

Hi Pushkal,
I was able to conclude your problem into 2 ways, both solutions have been given below-
Scenario 1-
The solution should be, first read the csv file using read csv activity (this will read your input and store it to datatable variable)
Then use output datatable activity. (To convert datatable values to string.)
moving ahead you can do any changes to this string as per your requirements.

Scenario 2- If your input is a string file which is structured as Comma seperated text.
Solution is using “Generate datatable from Text” activity.
adding screenshot for reference.

If you find the solution helpful, please like this response and drop a comment.