Adding data to a csv file


I have a csv with 4 columns which the BOT reads from to input data into different fields on a website. For each successful record updated I want to update the csv file ’ Success’ or ‘Failure’ depending on whether it was able to add the records or not.

The problem that I’m having is that the csv file changes format and where I originally had 4 columns of data I now have one column with all the other columns data combined.

Is there a solution for this?

Choose encoding while writing like UTF-32 or UTF-32BE encoding.
This generally occurs due to delimiter in CSV.

Thanks for responding. Not sure what you mean here? Where do I choose encoding?

In studio, you have property panel for each activity. Please mention it there.