Help with file format conversion please!

1 Ansicht (letzte 30 Tage)
Michel Nieuwoudt
Michel Nieuwoudt am 17 Sep. 2019
Kommentiert: Michel Nieuwoudt am 17 Sep. 2019
I have a set of numbers of XY data (.csv format), with each XY value in the format: 2.024890e 002,2.069117e 003. How do I convert to format 20248.90 2069.117 instead, i.e. nonscientific and spaces not commas? I have attached the file :)
Thank you, and sorry for the really basic question!

Akzeptierte Antwort

Stephan
Stephan am 17 Sep. 2019
% Setup the Import Options and import the data
opts = delimitedTextImportOptions("NumVariables", 2);
% Specify range and delimiter
opts.DataLines = [1, Inf];
opts.Delimiter = ",";
% Specify column names and types
opts.PreserveVariableNames = true;
opts.VariableNames = ["x", "y"];
opts.VariableTypes = ["double", "double"];
% Specify file level properties
opts.ExtraColumnsRule = "ignore";
opts.EmptyLineRule = "read";
% Import the data
xy = readtable("YOUR_FULL_FILE_PATH_HERE\xy.csv", opts);
% Convert to output type
xy = table2array(xy);
% Clear temporary variables
clear opts
  5 Kommentare
Stephan
Stephan am 17 Sep. 2019
Bearbeitet: Stephan am 17 Sep. 2019
You should follow Guillaumes advise - the code i used is the lazy way: Matlab auto generated code from the import tool (this is why it is that large). Therefore it is useful if you provide your Matlab release when asking questions here. If you do not, i have to assume you use the latest release...
Michel Nieuwoudt
Michel Nieuwoudt am 17 Sep. 2019
Thank you so much Guillaume :) , and thank you Stephan. I have the 2018b version; will add this next time.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Low-Level File I/O finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by