Adding data to a csv file


#1

Hi

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?


#2

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


#3

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


#4

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