Reading data from a file name

Hello MatLab Community,

I am loading csv files and am posed with a unique problem. The data file's name contains pertinent information that I need to extract. For example, one such file name is 'SUNY_072054055.csv' and I would like to extract 07205 from the file name as 072.05 and extract 4055 as 40.55. Both of these values I will set a variables to be used later on in future analysis.

I have already loaded the file names into matlab as strings. For example, files(1).name = 'SUNY_072054055.csv'

Any help would be appreciated.

Thanks to all,

Steven

Answer 1

[Walter Roberson]

find() the location of the '_' and of the '.' . Extract the string between those positions. Take the first 5 characters, str2double() it, and divide by 100. Take the last 4 characters, str2double() it, and divide by 100.

[Steven]

Thank you for the answer Walter. How do I tell MatLab to extract the string between the '_' and '.'?

Thanks,

Steven

[Image Analyst]

Use strfind() to find those characters. Then fn(index1:index2) to extract a string from fn in between index1 and index2 inclusive.

[Steven]

Walter, Image Analyst, thank you very much for your help. Your guiding light showed me the way :-)

All the best,

Steven