can you please help how to convert a csv file into ascii format?

I have a .csv file from a graph. I need to convert it to an ascii file format. I need to load this .ascii file on another software. please help thanks

[Walter Roberson]

Csv files are mostly ascii files, but sometimes they are utf8 encoded. Utf8 files are the same as ascii for up to position 176 or so, except that occasionally a utf8 file will start with a two byte "byte order mark"

[Stephen23]

"...how to convert a csv file into ascii format?"

What is the difference?

[Surya Gnyawali]

I know some csv files are ascii. but these files formed by a software called HS SpectralView which collects data cubes of hyperspectral imaging system. The graphical data are converted to comma delimated csv and I need to read these files in another software called "cytoSpec" which takes ascii files doesnt read. Any idea using matlab to read the spetral data in csv files will be highly appreciated.images are attached. Thanks

[Sammy]

Hello, I would also like to ask about this topic. I have a .csv file that I need to convert to .asc as it is the only format our instrument (SBE) reads. I tried changing my .csv into .asc directly by simple renaming but it still won't work. Can you teach me how? I attached my .csv file. Thanks.

[Stephen23]

@Sammy: Your file is already UTF8 and contains only ASCII characters. But it does have a BOM:

https://en.wikipedia.org/wiki/Byte_order_mark

I removed the BOM (using Notepad++) and uploaded it here.

[Adrienne Winter]

I had an issue where my csv was being read as an ASCII in Matlab - I saved the csv again with UTF-8 (with no BOM) from Notepad and this worked to make the csv readable (as I saw it was saved with BOM).

For anyone else who may have the same issue as me.

Answer 1

[Walter Roberson]

The file that was uploaded is already pure ASCII.

The only thing I notice is that it uses newlines alone for end of line; it is possible that the other program needs carriage-return as well as newlines. If so then

S = fileread('Wavelength (nm)_Counts.csv');

S = regexprep(S, '\n', '\r\n');

fid = fopen('Counts_with_CR.csv', 'w');
fwrite(fid, S);
fclose(fid);

Now Counts_with_CR.csv will have the same content but with CR/NL delimiter.

[Surya Gnyawali]

Thanks a lot. makes much more sense. The only confusion is that the output 'S' is now a 1x4059 char. Fid is #3. Which file should I use for uploading to CytoSpec software as pure ascii file? Please advise.

[Walter Roberson]

The code writes out a file Counts_with_CR.csv which would be what you would try with the CytoSpec software.