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

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!

[Chunru]

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);

Answer 1

[Chunru]

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);

[Simon Schmidt]

Awesome! What if want to create a new row with the first word (instead of 3 characters) of each row of the COL Name?

[Chunru]

Something like this:

FirstWord = data.name;     % copy the original name

for i = 1:length(FirstWord)
    % Split each origninal name and get the first word
    words = split(FirstWord(i));
    FirstWord(i) = words(1);
end

data = addvars(data, FirstWord);

[Simon Schmidt]

Great, thanks a lot!