Extracting specific column of values using regexp

I am currently trying to extract the X, Y, Z values from a .txt file. Any help is greatly appreciated!

3 Comments

Have you tried converting .txt file into excel/csv so that things can be easy?
I have :) Unfortunately, whilst it helped fix the delimination and presented the data more nicely, I didn't find that it made it any easier for me extract the data. Of course I'm a novice so I could be missing something! Is there anything you'd suggest?
Rather than a screenshot of a text file (with which we can't experiment), attach an actual file.

Sign in to comment.

Answers (1)

Your text file looks fairly ordinary. Matlab shouldn't have much problem importing using one of its many functions. Probably, the simplest would be to use readtable.
Without a file, I can't test but I believe
t = readtable('yourfile', 'HeaderLines, 1, 'Delimiter', 'tab')
should work, assuming you give it the right delimiter.

1 Comment

@Dhani Dharmaprani: it is usually much faster and simpler to read all of the data, and then use basic MATLAB indexing afterwards to select that data that you need.

Sign in to comment.

Categories

Find more on Environment and Settings in Help Center and File Exchange

Asked:

on 6 Sep 2016

Edited:

on 9 Sep 2016

Community Treasure Hunt

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

Start Hunting!