topic Re: Saving csv file with ANSI encoding in Product Forum

Saving csv file with ANSI encoding

NupurSood — Thu, 13 Oct 2022 20:57:47 GMT

Hello All

We have a usecase where we need to store a csv string in a text file. To achieve the same we are leveraging "Write text file" action in "Utility - file management". However, the csv file created has UTF-8 encoding but we desire "ANSI" encoding. Would you please be able to suggest a method for the same. We tried writing a code where we are able to define encoding type but it doesn't take "ANSI" to be a valid encoding type.

File.WriteAllText(File_Name, Text, System.Text.Encoding.GetEncoding(Encoding_Type))

Any guidance would be great help.

Thank YOu

Re: Saving csv file with ANSI encoding

ewilson — Fri, 14 Oct 2022 02:27:36 GMT

Hello @NupurSood,

GetEncoding() returns an Encoding object based on a input code page. If you know you want ASCII why not just pass Encoding.ASCII in the WriteAllText() method?

File.WriteAllText(File_Name, Text System.Text.Encoding.ASCII)

Cheers,
Eric

Re: Saving csv file with ANSI encoding

ewilson — Fri, 14 Oct 2022 02:48:50 GMT

I just realized you were asking about ANSI as opposed to ASCII. 🤦‍♂️ Apologies for my lack of reading comprehension.

What code page are you passing into GetEncoding()? Is it iso-8859-1?

Cheers,
Eric

Re: Saving csv file with ANSI encoding

NupurSood — Fri, 14 Oct 2022 16:38:19 GMT

Hello @ewilson

Thank you for your prompt response. I just need to be able to save a csv text as ANSI coded which can be done manually as shown in attached picture but we were hoping for a code for the same. I might be using the wrong command here but if i pass "Encoding_Type" as "UTF-8" the file gets saved as UTF-8. However if I pass "Encoding_Type" value as "ANSI", I get an error saying it is not a valid encoding

Re: Saving csv file with ANSI encoding

kirtimaantalwar — Fri, 14 Oct 2022 16:53:13 GMT

Hi @NupurSood,

Can you try by searching the required encoding from the list and using the .Net Name for the same as Encoding_Type.
https://learn.microsoft.com/en-us/windows/win32/intl/code-page-identifiers?redirectedfrom=MSDN

I hope this helps!!

Many Thanks,
KirtiMaan Talwar

Re: Saving csv file with ANSI encoding

ewilson — Fri, 14 Oct 2022 20:22:00 GMT

@NupurSood,

This works for me:

Dim data As String = "1,2,3,4,5,6,7,8,9,0"
System.IO.File.WriteAllText("C:\temp\TestFile.csv", data, System.Text.Encoding.GetEncoding("iso-8859-1"))

Cheers,
Eric

Re: Saving csv file with ANSI encoding

NupurSood — Wed, 19 Oct 2022 19:25:24 GMT

Hello @ewilson

I tried this but this still saves my file as UTF-8 encoding and not ANSI. Might I be missing some pre-condition here?

Regards
Nupur

Re: Saving csv file with ANSI encoding

NupurSood — Wed, 19 Oct 2022 19:54:55 GMT

Apologies, I had a typo.

That worked like a charm. Thank you so much for your help 🙂