MATLAB: How do you delete text data from a row if its characters are equal to or less than 3

if statement

How are these data currently stored? For example, do you have them in a cell array? Or in a CSV file, not yet loaded into MATLAB?

Best Answer

If you have the data in a cell array:

C = {'Trinidad & Tobago'
  'USD'
  'Turkey'
  'TRY'
  'USD'
  'Uganda'
  'UGX'
  'Ukraine'
  'USD'
  'United Arab Emirates'
  'USD'
  'United Kingdom'
  'USD'
  'United States'
  'USD'
  'Uruguay'
  'UYU'
  'Zambia'
  'USD'
  'NA'
  'BRL'
  'COP'
  'CZK'
  'EUR'}

then

C = C(cellfun(@(x)length(x)>3,C))

will keep only the longer entries, while

C(cellfun(@(x)length(x)<=3,C)) = {''}

will replace the 3-character entries with empty string.

Related Solutions

MATLAB: How can we find the non common strings from multiple columns

First lets find the strings that are common to all cell arrays:

listA={'India','Iran','Ireland','Israel','Jordan','Kuwait','Lebanon','Lesotho','Libya','Luxembourg','Malawi','Maldives','Morocco','Nepal','Netherlands','Norway','Oman','Paraguay','Peru','Philippines',};
listB={'Denmark','El Salvador','Gabon','Gambia','Lebanon','Lesotho','Libya','Luxembourg','Malawi','Maldives','Morocco','Nepal','Netherlands','Norway','Oman','Paraguay','Peru','Philippines','Qatar','Rwanda','Saudi Arabia','Senegal','Singapore','Sudan'};
listC={'Kuwait','Lebanon','Lesotho','Nepal','Netherlands','Oman','Sweden','Syria','Tanzania','Turkey','Uruguay'};
%

lists = {listA,listB,listC}; % storing data together makes working with them much simpler.
%
exc = lists{1};
for k = 2:numel(lists)
    exc = intersect(exc,lists{k});
end

giving the strings found in all cell arrays as:

 exc =
    'Lebanon'
    'Lesotho'
    'Nepal'
    'Netherlands'
    'Oman'

Now we can easily get the input cell arrays with the strings from exc removed:

out = cell(size(lists));
for k = 1:numel(lists)
    out{k} = setdiff(lists{k},exc);
end

giving:

>> out{:}
ans = 
    'India' 'Iran' 'Ireland' 'Israel' 'Jordan' 'Kuwait' 'Libya' 'Luxembourg' 'Malawi' 'Maldives' 'Morocco' 'Norway' 'Paraguay' 'Peru' 'Philippines'
ans =
    'Denmark' 'El Salvador' 'Gabon' 'Gambia' 'Libya' 'Luxembourg' 'Malawi' 'Maldives' 'Morocco' 'Norway' 'Paraguay' 'Peru' 'Philippines' 'Qatar' 'Rwanda' 'Saudi Arabia' 'Senegal' 'Singapore' 'Sudan'
ans =
    'Kuwait' 'Sweden' 'Syria' 'Tanzania' 'Turkey' 'Uruguay'

And if you want a list of all strings together, excluding those in exc:

uni = {};
for k = 1:numel(lists)
    uni = union(uni,lists{k});
end
uni = setdiff(uni,exc)

gives:

uni =
    'Denmark' 'El Salvador' 'Gabon' 'Gambia' 'India' 'Iran' 'Ireland' 'Israel' 'Jordan' 'Kuwait' 'Libya' 'Luxembourg' 'Malawi' 'Maldives' 'Morocco' 'Norway' 'Paraguay' 'Peru' 'Philippines' 'Qatar' 'Rwanda' 'Saudi Arabia' 'Senegal' 'Singapore' 'Sudan' 'Sweden' 'Syria' 'Tanzania' 'Turkey' 'Uruguay'

MATLAB: Indexing into a cell array to retrieve specific value

You would probably be better off using a table instead of a cell array.

In any case:

sj_name = 'xxxx@gmail.com';
ids = cell2mat(yourcellarray(strcmp(yourcellarray(:, 3), sj_name), 1));

If you are absolutely certain that there is only ever one match:

id = yourcellarray{strcmp(yourcellarray(:, 3), sj_name), 1};

Best Answer

Related Solutions

MATLAB: How can we find the non common strings from multiple columns

MATLAB: Indexing into a cell array to retrieve specific value

Related Question