MATLAB Answers

Get rid of array strings from readtable

11 views (last 30 days)
Jacob Rutgersson
Jacob Rutgersson on 24 Sep 2020 at 20:21
Commented: Star Strider on 24 Sep 2020 at 21:30
How do i get rid of the array strings on the "Precision" variable?

  0 Comments

Sign in to comment.

Answers (1)

Star Strider
Star Strider on 24 Sep 2020 at 20:45
Try this:
Precision = [{'91,6'}; {'91,1'}; {'90,4'}]; % Create Vector
T1 = table(Precision); % Create Table
T1.Precision = strrep(T1.Precision,',','.') % Necessary For Me (I Cannot Use ',' As Decimal Separator)
T1.Precision = str2double(T1.Precision) % Necessary
producing (nere):
T1 =
3×1 table
Precision
_________
91.6
91.1
90.4
.

  2 Comments

Jacob Rutgersson
Jacob Rutgersson on 24 Sep 2020 at 21:03
Ye, that works. Part of the exercise is too make it general (sadly). So i need them gone from start when i import them.
Im trying to find a Format command on the internet, like %s,%f and %u. But cant manage to find anything that fits..
Star Strider
Star Strider on 24 Sep 2020 at 21:30
I have no idea what sort of file ‘svenp’ is (text, spreadsheet, etc.). You can use detectImportOptions (and its friends), however in most situations I find it easier to just read the data in as strings or character arrays such as this, and then do the conversions.

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by