How do you write a .csv file into excel without carrying along the commas with it?

Here is my code to read and write the .csv file:

%-----------------------------------------------------------------------------------------------------------------------------------------

fileID = fopen(ExPath1);

c = textscan(fileID, '%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s');

fclose(fileID);

xlswrite('Book.xlsx', [c{:}])

%-------------------------------------------------------------------------------------------------------------------------------------------

The reason why I am reading in the data first is because I would like to alter the data and then save the newly altered data as an excel file.

Answer 1

[Caroline]

I think you can use textscan to specify the delimeter. For example:

c = textscan(fileID, '%s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s %s', 'delimeter', ',');

[Cordelle]

is there a way to declare multiple delimiters like ',' and ':' at the same time