Read CSV file with a specific newline delimiter

[antoine_pac]

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<br/>22;34;4323<br/>22;44;984<br/>22;6;389<br/> etc...

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

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

Thank you for your help !

[atcodedog05 · Accepted solution]

Hi @antoine_pac 

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

Workflow:

Hope this helps : )

[antoine_pac]

@atcodedog05thank you for your help !

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

[atcodedog05]

Hi @antoine_pac 

It should.

Happy to help : )

Cheers and have a nice day!