extracting a number from a cell

Hi,

I have a vector where each cell has the following format:

OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK. 

ARIZONA PUB.SVS. 1992 8 3/4% 15/01/24 EARLY

is there a way to extract the date 15/05/14 from the cell?

[Image Analyst]

Not from that one because it's not in there.

But in general

theString = ca{3}; % Or whatever cell it's in

substring = theString(index1:index2);

Answer 1

[Image Analyst]

For example:

ca = {'OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK. ARIZONA PUB.SVS. 1992 8 3/4% 15/01/24 EARLY'}
theString = ca{1}
theDate = theString(30:38)

Results in command window:

ca = 
    'OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK. ARIZONA PUB.SVS. 1992 8 3/4% 15/01/24 EARLY'
theString =
OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK. ARIZONA PUB.SVS. 1992 8 3/4% 15/01/24 EARLY
theDate =
 15/04/14

[joseph Frank]

the issue is that each cell has a different length "OHN HANCOCK LF.IN. 2004 5.32% 15/04/14 INDXLK" is one cell and "ARIZONA PUB.SVS. 1992 8 3/4% 15/01/24 EARLY" is another one

[Image Analyst]

Use strfind() to find the first slash, then back up until you hit a space. Or else find the % symbol, move up two characters and then find the first space after that and take everything in between. I think you should be able to figure it out once you look up strfind() in the help.