Extract first x characters in specific table column and place them in new column.

5 views (last 30 days)
Simon Schmidt
Simon Schmidt on 29 Apr 2021
Commented: Simon Schmidt on 30 Apr 2021
Hello,
i want to extract the first x characters of a specific column for every row in the table and create a new column with the extracts (see image).
Unfortunaly Im not able to do this...
Help is much appreciated!
  1 Comment
Chunru
Chunru on 30 Apr 2021
Using table and string functions:
data = table(["aaaaaa"; "bbbbbbb"; "ccccccc"], [2.99; 2.99; 3.99]);
data.Properties.VariableNames=["Name", "Value"];
newName = extractBetween(data.Name, 1, 3);
data = addvars(data, newName);

Sign in to comment.

Accepted Answer

Chunru
Chunru on 30 Apr 2021
data = table(["aaaaaa"; "bbbbbbb"; "ccccccc"], [2.99; 2.99; 3.99]);
data.Properties.VariableNames=["Name", "Value"];
newName = extractBetween(data.Name, 1, 3);
data = addvars(data, newName);
  3 Comments

Sign in to comment.

More Answers (0)

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!