Conveter a string with space in a number

2 views (last 30 days)
A have one vector returned by the function textscan which have spaces inside the numerical string.
E.g.:
' 0 0 , 2 3 '
' 1 2 , 1 5 '
First, a have to substitute the ',' by '.' (it's simple) but how I remove the spaces? Because using str2num in this vector is returned error.
  2 Comments
Stephen23
Stephen23 on 26 Aug 2020
Edited: Stephen23 on 26 Aug 2020
"A have one vector returned by the function textscan which have spaces inside the numerical string."
I am surprised that no one brought up the obvious solution, to fix the (likely) problem at its source by handling the file encoding properly. Then textscan would import the data correctly.
Image Analyst
Image Analyst on 26 Aug 2020
Well, someone might have, but the original poster forgot to attach the original text file. That is a common omission. For some reason, many/most posters totally ignore the posting guidelines that they are shown when they post the question, one of which says to attach their data.

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 20 Jun 2015
It's pretty much the same except that you set it equal to [] instead of a decimal point:
str(str == ' ') = []; % Remove spaces
  3 Comments
Walter Roberson
Walter Roberson on 20 Jun 2015
cellfun(@(str)str(str~=' '), dataArray, 'Uniform', 0)
Walter Roberson
Walter Roberson on 20 Jun 2015
cellfun(@(str)str(2:2:end), dataArray, 'Uniform', 0)
in the case where the odd-numbered characters are the blanks.

Sign in to comment.

More Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 20 Jun 2015
Edited: Azzi Abdelmalek on 20 Jun 2015
s={' 0 0 , 2 3 ';'1 2 , 1 5 '}
a=strrep(s,',','.')
b=strrep(a,' ','')
out=str2double(b)

Categories

Find more on Data Import and Export 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!