Seperate numbers in string to different array

3 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'}

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.


Find more on Characters and Strings 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!