Split structured text delimated by comma in a table column
42 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have a table containing a variable for airport which has structured string values like Airport = ["MUMBAI,BOM";"NEW DELHI, DLH"; "JAIPUR,JAI";.......] How to split this variable in two different new variables in same table with one variable having location and another as loaction code.
0 commentaires
Réponses (2)
the cyclist
le 3 Mar 2023
Modifié(e) : the cyclist
le 3 Mar 2023
% Create the sample input table
Airport = ["MUMBAI,BOM"; "NEW DELHI, DLH"; "JAIPUR,JAI"];
tbl = table(Airport);
% Create temporary string array, with two columns split at the comma
tmp= split(tbl.Airport,",");
% Extract the location, and put in table
tbl.Location = tmp(:,1);
% Extract the code, and put in table
tbl.Code = tmp(:,2);
tbl
You have an extra space for the New Delhi airport. If that is a problem there are functions for removing whitespace.
0 commentaires
Morgan
le 3 Mar 2023
Try using the function
newStr = split(Airport,',');
You may need to wrap the first argument with string(Airport) to make sure everything is formatted properly for the split function.
This will create an N-by-2 array, the first column will be the location string and the second column is the location code string.
Let me know if you need anything else!
- Morgan Blankenship, MS, EIT
0 commentaires
Voir également
Catégories
En savoir plus sur Characters and Strings dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!