find the matching strings in tables

Question

Birsen 2016-9-23

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304284-find-the-matching-strings-in-tables

编辑： Walter Roberson 2016-9-24

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2016-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304284-find-the-matching-strings-in-tables#answer_235887

在 MATLAB Online 中打开

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

2 个评论
显示无隐藏无

Birsen 2016-9-24

编辑：Walter Roberson 2016-9-24

在 MATLAB Online 中打开

Walter, Thank you for the answer. You are right I had to give a demo. Unfortunately your suggestion did not work. It did not give an error but did not change the result neither.

Here it is what I have;

filename='BkgData.xls'
YourTable = readtable(filename);

Here it is how my table looks like

Country         Locations           ........
=======              ========       ==========
'Argentina'    'Argentina-Area1,CityA-52'
'Belgium'      'Belgium-Area5, 346_6

.................

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

The 'Argentina-Area1,CityA-52' still stands there as a one piece.

Thanks again

Birsen 2016-9-24

Walter,

I was wrong. I made a mistake when i tried for the first time. Your code solved the problem. Thanks again.

Birsen

请先登录，再进行评论。

Answer 2

George 2016-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304284-find-the-matching-strings-in-tables#answer_235885

在 MATLAB Online 中打开

You can use regexp.

a = 'Country1-Area1,CityA-52';
expression = '-.+$'; % a dash, one or more characters until the end of the line
[token, ~] = regexp(a, expression, 'match');
token{1}(2:end) % lop off the dashes
ans =
1×11 char array
Area1,CityA-52

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Birsen 2016-9-24

George, Thank you. Your code works great when the string is a single line, but I have a table. Actually 'a" here is a Table not a single line string. In the table there are thousands of line like "a". I can go around and use your code but there got to be a easier way to split the stings and rearrange columns in Table. Thanks Again

Birsen

请先登录，再进行评论。

Answer 3

Image Analyst 2016-9-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/304284-find-the-matching-strings-in-tables#answer_235886

What about using the strrep() function? If you'd given code for making a demo table, I might have tried it for you. You gotta make it easy for us, or at least that helps.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Birsen 2016-9-24

Image Analyst;

I can see I did not provide enough information. Thank you though. strrep() function is to find and replace the matching strings. If I had only a couple of line that would help but here I am trying to split hundreds of them and each time the string (country name) is different. And they are located in a Table column.

Birsen

请先登录，再进行评论。