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

1 view (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.

0 Comments

2 Answers

Link

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

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 on 7 Sep 2016

I don't know if you have tested my code!

Link

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

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.

You are now following this question

Tyler Murray (view profile)