MATLAB Answers

Info

This question is closed. Reopen it to edit or answer.

extracting a number from a cell

1 view (last 30 days)
joseph Frank
joseph Frank on 11 Feb 2012
Closed: MATLAB Answer Bot on 20 Aug 2021
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?
  1 Comment
Image Analyst
Image Analyst on 11 Feb 2012
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);

Answers (1)

Image Analyst
Image Analyst on 11 Feb 2012
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
  2 Comments
Image Analyst
Image Analyst on 11 Feb 2012
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.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by