replacing string variables with others

1 次查看（过去 30 天）
tzaloupas
tzaloupas 2013-2-1
Dear all,
I have an excel file which I import into matlab.
This file is of size 400000 by 29
Among other columns I have a column that contains text information
For instance here is some of the text information
textinfo={
'A'
'DRG MARS'
'FO'
'HYRETS > 250'
'HYPERET > 250SQ'
'LARGROIES 25-3'
'LARG SURMATS 1-29'
'SALL GRIES UP TO 25Q'
'SUEMATS 40-9S'};
I want to find a code that will do the following mapping automatically
Replace 'A' by 'SE1' (for example)
Replace 'DRG MARS' by 'SE5'
Replace 'FO' by 'SE04' and so on
So as to create another column that will contain the 'SE1' 'SE04' etc corresponding to the text information according to the previous mapping mechanism
This matrix is large and doing this manually would be impossible
thanks a lot

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

采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-2-1
编辑：Azzi Abdelmalek 2013-2-1
s1={'A','DRG MARS','FO'};
s2={'SE1','SE5','SE04'};
for k=1:numel(s1)
textinfo=cellfun(@(x) regexprep(x,s1{k},s2{k}),textinfo,'un',0);
end
textinfo

更多回答（2 个）

Thorsten
Thorsten 2013-2-1
newtextinfo = textinfo;
idx =find(strcmp(textinfo, 'A'));
for i=1:numel(idx)
newtextinfo{i} = 'SE1';
end
Jos (10584)
Jos (10584) 2013-2-1
Short and simple: STRREP
a = {'A','b','A','t'} ;
strrep(a,'A','xxx')
% ans = 'xxx' 'b' 'xxx' 't'

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Export 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by