how to remove comma from certain items only from cell array with several items

Question

azim 2017-4-5

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333745-how-to-remove-comma-from-certain-items-only-from-cell-array-with-several-items

评论： azim 2017-4-5

hey all, i'am new to matlab and i have a query. i have a single cell array as following:

charstring={'"98,786","103,630","95,758","99,871","106,916",494,361,"92,793","81,741","79,919","79,919",999,989,999'}

this has some items in quotes and others without quotes. what i need to do is remove the ,(comma) character from only those numbers which are between quotes. so my final answer should look like:

charstring={'"98786","103630","95758","99871","106916",494,361,"92793","81741","79919","79919",999,989,999'}

i have tried all combination of strrep replaceBetween regexprep but could not get my head around this question. any help on this matter would be highly appreciated. thanks, azim

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2017-4-5

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333745-how-to-remove-comma-from-certain-items-only-from-cell-array-with-several-items#answer_261831

编辑：Stephen23 2017-4-5

在 MATLAB Online 中打开

This is easy with regexprep:

>> str = {'"98,786","103,630","95,758","99,871","106,916",494,361,"92,793","81,741","79,919","79,919",999,989,999'};
>> out = regexprep(str,'("\d+),(\d+")','$1$2')
out = 
    "98786","103630","95758","99871","106916",494,361,"92793","81741","79919","79919",999,989,999

5 个评论
显示 3更早的评论隐藏 3更早的评论

Guillaume 2017-4-5

regular expression is like any other language (programming or otherwise). If you don't know it, it looks and sounds like gibberish. If you do know it, then it's easy to understand. Certainly, Stephen's expression here is very low on the complexity scale of regular expressions. It's only two capture groups each consisting of digits and " and separated by a comma. Yet, it does the job perfectly.

azim 2017-4-5

beautiful answer...thanks for the help and the great explanation. i hope i become as good as you guys in coding.

请先登录，再进行评论。

Answer 2

Jan 2017-4-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/333745-how-to-remove-comma-from-certain-items-only-from-cell-array-with-several-items#answer_261828

编辑：Jan 2017-4-5

在 MATLAB Online 中打开

C = {['"98,786","103,630","95,758","99,871","106,916",494,361,"92,793",', ...
      "81,741","79,919","79,919",999,989,999']}
D         = strsplit(C{1}, ',');
quoted    = strncmp(D, '"', 1);
D(quoted) = strrep(D(quoted), ',', '');  % [EDITED] Typos
Str       = sprintf('%s,', D{:});
CleanC    = {Str(1:length(Str)-1)};  % remove trailing comma