Hi, I apologize for my "noob" question. I have a csv file which I download from a URL with the following pattern : periode;ID;nbPrev 22;34;4323 22;44;984 22;6;389 etc... And I want to read it as a 3 column table, with the classic seperator ";". But how can I interpret the delimiter " " as a newline delimiter to read the file correctly ? Thank you for your help !

Read CSV file with a specific newline delimiter

Hi,

I apologize for my "noob" question.

I have a csv file which I download from a URL with the following pattern :

periode;ID;nbPrev 22;34;4323 22;44;984 22;6;389 etc...

And I want to read it as a 3 column table, with the classic seperator ";".

But how can I interpret the delimiter " " as a newline delimiter to read the file correctly ?

Thank you for your help !

Input

The only thing you can do is prep the data after reading it like below.

Workflow:

Hope this helps : )

The only thing you can do is prep the data after reading it like below.

Workflow:

Hope this helps : )

@atcodedog05thank you for your help !

This solution works, even if I have a huge file as input ?

It should.

Happy to help : )

Cheers and have a nice day!