extracting percentages from text

16 views (last 30 days)
Claire Liu
Claire Liu on 29 Nov 2023
Commented: Peter Perkins on 29 Nov 2023
Hi,
I have a .txt data file, like this,
9.26E-02 22% 2.363 ABC
How can I read it into a MATLAB table with four elements?

Answers (1)

Dyuman Joshi
Dyuman Joshi on 29 Nov 2023
  2 Comments
Image Analyst
Image Analyst on 29 Nov 2023
@Claire Liu did you try it yet? It should have worked - it's what I would have suggested. If not, attach an actual txt file with the paperclip icon.
If this Answer solves your original question, then could you please click the "Accept this answer" link to award the answerer with "reputation points" for their efforts in helping you? They'd appreciate it. Thanks in advance. 🙂 Note: you can only accept one answer (so pick the best one) but you can click the "Vote" icon for as many Answers as you want. Voting for an answer will also award reputation points.
Peter Perkins
Peter Perkins on 29 Nov 2023
readtable is a start, but likely you will end up with "22%" as text. At that point, you will probably want to do something like t.Var2 = sscanf(t.Var2,"%d%%")/100.

Sign in to comment.

Categories

Find more on Language Support 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!