readtable disfigures the CSV file header
2 views (last 30 days)
Show older comments
I need to remove the units within brackets from my CSV file, attached.
ID par1 (mol) par2 (meter^3) par3 (kg/L)
1 4 5 11
2 3 6 10
3 2 7 9
4 1 8 8
here the basic code I tried
data = readtable('headerFile.csv','ReadVariableNames', true);
headerRow = data.Properties.VariableNames
readtable however messes up the header (raplaces special characters with '_') and instead of
{'ID'} {'par_1 (mol)'} {'par_2 (meter^3)'} {'par_3 (kg/L)'}
I get
headerRow =
1×4 cell array
Columns 1 through 4
{'ID'} {'par_1_mol_'} {'par_2_meter_3_'} {'par_3_kg_L_'}
What is the best way to extract the actual header?
0 Comments
Accepted Answer
Stephen23
on 11 May 2023
data = readtable('headerFile.csv','ReadVariableNames', true, 'VariableNamingRule','preserve')
0 Comments
More Answers (1)
Mathieu NOE
on 11 May 2023
hello
here you are :
headerRow = {'ID'} {'par_1 (mol)'} {'par_2 (meter^3)'} {'par_3 (kg/L)'}
data = readtable('headerFile.csv','ReadVariableNames', true,'VariableNamingRule' , 'preserve');
headerRow = data.Properties.VariableNames
0 Comments
See Also
Categories
Find more on Downloads in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!