MATLAB: Find the matching strings in tables

string matchtable

Hi,

I have an excel file and I converted to a table. My table has a column called "Locations". The location column contains a long list of string like " Country1-Area1,CityA-52". I would like to rename the sites as follows: Area1,CityA-52. I tried many things to find the first "-" index number in a table. I thought if I find the first index number then I could read the rest of the string. Could not succeed so far. Since it is a table it is more complicated. Any ideas?

Thank you Birsen

Best Answer

YourTable.Locations = regexprep( YourTable.Locations, '^[^-]+-', '', 'lineanchors');

Related Solutions

MATLAB: Table2array gives string array when contents are numbers

I suspect data in sr_p and x5mmlinyeild are chars or strings and not doubles. What is the data type of the columns of your table? Look at the results of summary(sr_p) and summary(x5mmlinyeild).

If that doesn't seem to be the problem, please save your variables to a mat file and attach them to your post using the paperclip icon.

MATLAB: Splitting a Table at Every N Rows

You can use this script to split your table as mentioned in the question. Replace myTable with the name of your table. It will create a cell array seperatedCountries.

nunberCountries = 75;
noumberYears = 58;
rowOndexVector = repelem(1:nunberCountries, noumberYears);
seperatedCountries = splitapply(@(x) {x}, cell2mat(myTable{:,:}), findgroups(rowOndexVector));

seperatedCountries{1} will contain data about first country (i.e. Argentina). Similarly seperatedCountries{1} will contain data about second country (i.e. Austria) as so on.

Best Answer

Related Solutions

MATLAB: Table2array gives string array when contents are numbers

MATLAB: Splitting a Table at Every N Rows

Related Question