Info

此问题已关闭。 请重新打开它进行编辑或回答。

extracting a number from a cell

1 次查看（过去 30 天）
joseph Frank
joseph Frank 2012-2-11
关闭： MATLAB Answer Bot 2021-8-20
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 个评论
Image Analyst
Image Analyst 2012-2-11
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);

此问题已关闭。

回答（1 个）

Image Analyst
Image Analyst 2012-2-11
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 个评论
joseph Frank
joseph Frank 2012-2-11
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
Image Analyst 2012-2-11
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.

此问题已关闭。

标签

Community Treasure Hunt

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

Start Hunting!

Translated by