Convert CSV Unicode Text type to CSV MS-DOS type

[Enna]

I have multiple large CSV files. I would like to change the file type from Unicode text to MS-DOS without opening all the files. Is there a way to do that? Thank you

 

[rlv01]

What kind of Unicode, specifically?

 

[Enna]

What kind of Unicode, specifically?

It says “Unicode Text” - I think it is utf-8

 

[rlv01]

It says “Unicode Text” - I think it is utf-8

There a few different kinds of Unicode. Some like UTF-8 do not generally require any conversion.

Unicode - Wikipedia

en.wikipedia.org

Comparison of Unicode encodings - Wikipedia

en.wikipedia.org

Your conversion question cannot be answered without the details of the specific UTF type/encoding of the files that you want to convert. You can determine the type by examining the Byte Order Marker (BOM) at the beginning of your Unicode .csv file. Alternatively, there is this free ware text editor that will display the encoding in the statusbar at the bottom. It should also convert the file to a different encoding, but only one by one.

EditPad Lite - Free Text Editor for Windows

EditPad Lite: A fine text editor with all the necessary basic features. Free for non-commercial use. An ideal replacement for Notepad.

www.editpadlite.com

 

[Enna]

It says “Unicode Text” - I think it is utf-8

I would like to change Ms-dos otherwise I could not use, but there are many Csv files (all files within one folder) and they are very large. Is there a vba code ? Thank you

 

[rlv01]

I would like to change Ms-dos otherwise I could not use, but there are many Csv files (all files within one folder) and they are very large. Is there a vba code ? Thank you

I don't understand. If it really is UTF-8 you should be able to use that .csv exactly as if it was a "DOS" generated CSV. No conversion. No special treatment.

 

[Enna]

I don't understand. If it really is UTF-8 you should be able to use that .csv exactly as if it was a "DOS" generated CSV. No conversion. No special treatment.

Maybe it is a comma dlm csv because when I open and changed to Ms-dos I could use.

 

[rlv01]

A very simple way that may work for you is to open a Windows command window (cmd.exe) and type this command:

TYPE MyUnicodeFile.csv > MyASCIIFile.csv

Try it one one file, and if it works then to process many files, create a window batch file with an entry for each file you want to convert. i.e.

TYPE MyUnicodeFile1.csv  >   MyASCIIFile1.csv
TYPE MyUnicodeFile2.csv  >   MyASCIIFile2.csv
TYPE MyUnicodeFile3.csv  >   MyASCIIFile3.csv
TYPE MyUnicodeFile4.csv  >   MyASCIIFile4.csv
TYPE MyUnicodeFile5.csv  >   MyASCIIFile5.csv
TYPE MyUnicodeFile6.csv  >   MyASCIIFile6.csv
TYPE MyUnicodeFile7.csv  >   MyASCIIFile7.csv
TYPE MyUnicodeFile8.csv  >   MyASCIIFile8.csv
TYPE MyUnicodeFile9.csv  >   MyASCIIFile9.csv
TYPE MyUnicodeFile10.csv  >   MyASCIIFile10.csv
TYPE MyUnicodeFile11.csv  >   MyASCIIFile11.csv
TYPE MyUnicodeFile12.csv  >   MyASCIIFile12.csv
TYPE MyUnicodeFile13.csv  >   MyASCIIFile13.csv
TYPE MyUnicodeFile14.csv  >   MyASCIIFile14.csv
TYPE MyUnicodeFile15.csv  >   MyASCIIFile15.csv
TYPE MyUnicodeFile16.csv  >   MyASCIIFile16.csv
TYPE MyUnicodeFile17.csv  >   MyASCIIFile17.csv
TYPE MyUnicodeFile18.csv  >   MyASCIIFile18.csv
TYPE MyUnicodeFile19.csv  >   MyASCIIFile19.csv
TYPE MyUnicodeFile20.csv  >   MyASCIIFile20.csv

 

[Marc L]

It says “Unicode Text” - I think it is utf-8

Hi, maybe it's a BOM file so if you can link one original file and its 'MS-DOS' version on a files host website like Dropbox in order to check them …​

 

[Enna]

Hi, maybe it's a BOM file so if you can link one original file and its 'MS-DOS' version on a files host website like Dropbox in order to check them …​

Hi. I dont have Dropbox account and those csv files so large. Also, I do not have an access via cmd. So, how can I change multiple csv files in one folder without opening from "unicode text" CSV file to " CSV MS-DOS" file? Thank you