how to delete part of a string

I have thousands of string variables from where I want to delete some character (both from start and end). For example I want to convert

 'TENSOR 27_SN2837_CSN_PROV1_20130209.0.csv' to CSN_PROV1_20130209 
'TENSOR 27_SN2837_CSN_WADC1_20131004.0.csv'   to CSN_WADC1_20131004 
............
...........
Any suggestions?. Thanks

Answer 1

[Star Strider]

There may be more efficient ways to do this, but if all the original strings are the same length, this works:

V = ['TENSOR 27_SN2837_CSN_PROV1_20130209.0.csv'
    'TENSOR 27_SN2837_CSN_WADC1_20131004.0.csv'];
for k1 = 1:size(V,1)
    I1 = strfind(V(k1,:), 'CSN');
    I2 = strfind(V(k1,:), '.0');
    W(k1,:) = V(k1,I1:I2-1);
end

producing:

W =

CSN_PROV1_20130209
CSN_WADC1_20131004

[Mohammed Kamruzzaman]

Thanks Star Strider.

[Star Strider]

My pleasure.

[Mohammed Kamruzzaman]

Hi Star, How I can add quotes to the above. Thanks for your help I need

 "CSN_PROV1_20130209"

"CSN_WADC1_20131004"

[Star Strider]

This is probably the easiest way:

M = ['CSN_PROV1_20130209';
'CSN_WADC1_20131004'];

for k1 = 1:size(M,1)
    double_quotes(k1,:) = sprintf('"%s"',M(k1,:));
    single_quotes(k1,:) = sprintf('''%s''',M(k1,:));
end

producing:

double_quotes =

"CSN_PROV1_20130209"
"CSN_WADC1_20131004"

single_quotes =

'CSN_PROV1_20130209'
'CSN_WADC1_20131004'

This keeps them with the quotes in your workspace. If you need to print them to a file with the quotes, specify a file ID with fopen and replace sprintf with fprintf. Remember to use fclose to close the file when you’re finished with it.

As always, my pleasure.

[Mohammed Kamruzzaman]

you are great. Thank you so much.

[Star Strider]

My pleasure.