Converting txt file string to matrix.

2 views (last 30 days)
I have an unhelpful txt file containing a string that looks something like:
{co-ordinates 1.5 2.5 4.8 weighting 11.7}{co-ordinates 2.5 2.8 1.7 weighting 21.4}{co-ordinates 1.5 2.5 4.8 weighting 11.7} .... etc
I'm trying to create a matrix with 4 collums (x co-ord, y co-ord, z co-ord, weighting) from this string. The co-ordinated are separated by a single space, the co-ords and weighting is separated by a double space.
Thanks in advance.
  2 Comments
KSSV
KSSV on 31 Mar 2020
Read about textscan.
Hannah Taylor
Hannah Taylor on 31 Mar 2020
Is this similar to sscanf? I've been looking into this but unsure how to go about the 'format spec' part to say e.g. 'read the number after 'co-ordiantes ''

Sign in to comment.

Accepted Answer

Stephen23
Stephen23 on 31 Mar 2020
Edited: Stephen23 on 31 Mar 2020
>> str = '{co-ordinates 1.5 2.5 4.8 weighting 11.7}{co-ordinates 2.5 2.8 1.7 weighting 21.4}{co-ordinates 1.5 2.5 4.8 weighting 11.7}';
>> mat = sscanf(str,'{co-ordinates%f%f%f weighting%f}',[4,Inf]).'
mat =
1.5 2.5 4.8 11.7
2.5 2.8 1.7 21.4
1.5 2.5 4.8 11.7
  1 Comment
Hannah Taylor
Hannah Taylor on 31 Mar 2020
Thanks that's really helpful! I was struggling to understand the format spec part of sscanf but this has really helped :) life saver!!!

Sign in to comment.

More Answers (0)

Categories

Find more on Characters and Strings in Help Center and File Exchange

Products


Release

R2019b

Community Treasure Hunt

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

Start Hunting!