Loop through CSV file with different delimeters

Ui.Vision General Discussion
1

Hi forum

I would really like some assistance.

I would like to read a csv file that contains, a list a videos, each video contains a headline and transcript, the headline is separated by a pipe “|” as a delimiter from the transcript, and the transcript has paragraphs. Each transcript is delimited by a semi-colon “;”

How would I loop through the files to store the headline in one variable and the transcript in another and go through all the videos incrementally?

I so appreciate your help.

2

The rpa software can only read the classic CSV files, with " A", "B","C",… or simply A,B ,C,.

So the solution is to convert your file in this format. You can write a small script to do it, or ask ChatGPT/Gemini to convert the file for you :wink:

1 Like
3

Thank you for your feedback, will give that a try, much appreciated!