Seperate numbers in string to different array

2 views (last 30 days)
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.

Answers (2)

Azzi Abdelmalek
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
Tyler Murray
Tyler Murray on 7 Sep 2016
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.
Azzi Abdelmalek
Azzi Abdelmalek on 7 Sep 2016
I don't know if you have tested my code!

Sign in to comment.


Star Strider
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
Tyler Murray
Tyler Murray on 7 Sep 2016
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.

Tags

Community Treasure Hunt

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

Start Hunting!