Extract first x characters in specific table column and place them in new column.
35 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Simon Schmidt
il 29 Apr 2021
Commentato: Simon Schmidt
il 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).
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/601730/image.bmp)
Unfortunaly Im not able to do this...
Help is much appreciated!
1 Commento
Chunru
il 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);
Risposta accettata
Chunru
il 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 Commenti
Chunru
il 30 Apr 2021
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);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Characters and Strings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!