Utility - File Management, HTML2CSV

harshithaakumar — Wed, 14 Feb 2024 13:15:00 GMT

Hello Everyone.

I need to convert HTML Data into CSV. The HTML Data is stored in a Text Data Item. When I copy paste the HTML Value (manually) from the Data Item (Copy - Paste) into a Text File and convert it using the Python Code (html2csv), I am getting a good CSV File.

However, when I try to create a text file using Blue Prism, Utility - File Management, Action - Write Text to File or Append Text to File, and then when I use the Python Code (html2csv) to convert it, I am getting a bad CSV.

There are extra characters getting added into the CSV File. I am assuming this is because while creating a Text File via Blue Prism, there are extra characters getting added to the File.

Do you know what could be the cause for this issue and how it can be resolved.

Thank you in advance for the help!

------------------------------
Harshitha A Kumar
------------------------------

RE: Utility - File Management, HTML2CSV

John__Carter — Wed, 14 Feb 2024 18:25:00 GMT

You'll probably need to write a bespoke version of the Write Text File action that specifies UTF8 encoding (to deal with the French character diacritics).

------------------------------
John Carter
Blue Prism
------------------------------

topic RE: Utility - File Management, HTML2CSV in Product Forum

Utility - File Management, HTML2CSV

RE: Utility - File Management, HTML2CSV