How to split string

Hi,

I have the below cell array and want to split at common dilimiter of the specified column.

Group Sub_group Name Date Value

Group1 S1Gp11 HATU R2016-06-01_00 1

Group1 S1Gp11 HATU R2016-06-01_01 1

Group2 J1Gp21 LARU R2016-06-02_01 0

I want to split at "_" and retain everything before "_".

Desired Output:

Group Sub_group Name Date Value

Group1 S1Gp11 HATU R2016-06-01 1

Group1 S1Gp11 HATU R2016-06-01 1

Group2 J1Gp21 LARU R2016-06-02 0

[Adam Danz]

It looks like a table, are you sure it's a cell array? Is it a 4x5 cell array?

[Mekala balaji]

yes, cell array.

[Adam Danz]

Ok, good. See the example in my answer below and feel free to follow-up with any problems or questions.

Answer 1

[Adam Danz]

Use regexprep()

c = {'Group'     'Sub_group'  'Name'   'Date'             'Value';
     'Group1'    'S1Gp11'     'HATU'   'R2016-06-01_00'    '1'
     'Group1'    'S1Gp11'     'HATU'   'R2016-06-01_01'    '1'}; 

colIdx = strcmpi(c(1,:),'Date');  % column number of "Date" column
cClean = c; %copy the array if you want to keep the original
cClean(:,colIdx) = regexprep(cClean(:,colIdx),'_.*','');

Result

cClean =
  3×5 cell array
    {'Group' }    {'Sub_group'}    {'Name'}    {'Date'       }    {'Value'}
    {'Group1'}    {'S1Gp11'   }    {'HATU'}    {'R2016-06-01'}    {'1'    }
    {'Group1'}    {'S1Gp11'   }    {'HATU'}    {'R2016-06-01'}    {'1'    }