MATLAB Answers

0

Seperate numbers in string to different array

Asked by Tyler Murray on 7 Sep 2016
Latest activity Commented on by Tyler Murray on 7 Sep 2016
I import a text file using textscan and use vertcat to assign each line of the file its own cell. I am working with data to where it says something like: take off time 0.102 sec sensor1 initiated .361 sec, -31 (mv) sync at 50 ms and this continues for about 42 rows of data. My end goal is to separate all the numeric data from the words. For example have an array that would show [.102; .361 -31; 50;....]. I have tried regexp and sscanf but have had no luck.

  0 Comments

Sign in to comment.

Tags

2 Answers

Answer by Azzi Abdelmalek
on 7 Sep 2016

str={'take off time 0.102 sec';'sensor1 initiated .361 sec, -31 (mv)';'sync at 50 ms'}
out=regexp(str,'\s[-\d\.]?\.?\d+','match')
out=str2double([out{:}])

  2 Comments

Thanks for the answer Azzi, I had something similar to this but the problem is since it only gives the character number where it starts at, a number such as 0.12 will give indices of [1,3] (it doesn't count the decimal as part of the number). It also doesn't give insight to how large the number is. If I was to display character [1:3] in my example above it would display 0.1 instead of 0.12.
I don't know if you have tested my code!

Sign in to comment.


Answer by Star Strider
on 7 Sep 2016

See if this does what you want:
str = 'take off time 0.102 sec sensor1 initiated .361 sec, -31 (mv) sync at 50 ms';
nbrvct = cellfun(@str2num, regexp(str, '\d+\.\d+|\.\d+|\-\d+|\d+', 'match'))
nbrvct =
0.102 1 0.361 -31 50

  1 Comment

Thanks Star, this is similar to what I am looking for but got an error since each string is assigned to a cell. Error using str2num Requires string or character array input. I have it this way because I was trying to search for a phrase, figure out what cell it was in and display the number/numbers associated with that cell. Since the format can change a horizontal display may not work.

Sign in to comment.