Conveter a string with space in a number

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.
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

It's pretty much the same except that you set it equal to [] instead of a decimal point:
str(str == ' ') = []; % Remove spaces

3 Comments

How I can use this in this data annex (it's a cell data)? I try cellfun(@(str)str(str~=' '),dataArray{1,2}) but not work.
cellfun(@(str)str(str~=' '), dataArray, 'Uniform', 0)
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)

s={' 0 0 , 2 3 ';'1 2 , 1 5 '}
a=strrep(s,',','.')
b=strrep(a,' ','')
out=str2double(b)

Categories

Asked:

on 20 Jun 2015

Edited:

on 26 Aug 2020

Community Treasure Hunt

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

Start Hunting!