topic RE: Convert Excel or csv files to ASCII format in Product Forum

Convert Excel or csv files to ASCII format

Sudersan_RaoS — Thu, 11 Aug 2022 14:08:00 GMT

HI

I need to convert excel/csv files to ASCII format. Is there a way to do so using Blueprism

------------------------------
Sudersan Rao S
------------------------------

RE: Convert Excel or csv files to ASCII format

PabloSarabia — Thu, 11 Aug 2022 15:03:00 GMT

Hi @Sudersan Rao S,

You only can change the format to CSV files. Excel file are not formatted as such because it is not a plain text file.

To change this you can use some code, cause I think there is no specific VBO for this.

I modify a little bit the VBO "Utility - File Management" to add new action called "Change encoding to Ascii". You only need to give as input parameter the file path.

The code behind is simple:

Dim text = File.ReadAllText(strFileName, Encoding.Default)

File.WriteAllText(strFileName, text, Encoding.ASCII)

Hope this helps you!

See you in the Community, bye :)

------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------

RE: Convert Excel or csv files to ASCII format

arunmahe — Thu, 11 Aug 2022 15:19:00 GMT

Hi Pablo Sarabia,

Can we do the same for .txt files?

------------------------------
Arun Kumar
------------------------------

RE: Convert Excel or csv files to ASCII format

EmersonF — Thu, 11 Aug 2022 16:35:00 GMT

Hi, Arun Kumar, yes, you can!

------------------------------
Emerson Ferreira
Cons, Intelligent automation
Avanade Brasil
Recife
+5581988869544
If my answer helped you? Mark as useful!
------------------------------