How to extract data from a srting?

2013 1 31
2 个回答
回答已采纳
4 次查看（30 天）

0 个投票

Hi,
*I have this data as a single string *
Physical Location (City):Virginia
Manager of this associate:Donna Harding
Start Date:1-1-99
ID Type:Logon for SUPERVALU associate
For Transfer Requests From Dept:
Transfer Date:
Previous UserID:
Departure Date:
Middle Name:
I want to extract the name of the manager from the
Manager of this associate:Donna Harding
I mean I want data in the above string after : to be stored in other variable.
Could anyone help me in doing this?
Thank You

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Jan
Jan 2013-1-31
Please post the input in valid Matlab syntax. If matters if this is a cell string, or if the lines are separated by CHAR(10) linebreaks, or if they are not separated, or if this "string" is written to a file. Does the string contain a blank line after each line of text or does this occur in the forum only? As soon as the data are defined by valid Matlab syntax, all these questions implicitly vanish.
Vinay kumar Reddy
Vinay kumar Reddy 2013-1-31
Hi The posted one is the matlab input. I got a cell array,in which each cell has entire above mentioned data. each cell has different attribute for manager of the associate field.
and it has a empty line between every two lines. Thank You
Jan
Jan 2013-1-31
This description as a text does not enlighten me. What is "the Matlab input"? Each cell has the data? Do you mean a cell string? With one line per cell element, or with one string and line breaks?
Again I suggest to post Matlab code due to the unbeatable clarity.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Cedric
Cedric 2013-1-31
编辑：Cedric 2013-2-1

1 个投票

Solution with a regexp:
regexp(s, '(?<=associate:).*(?=Start)', 'match')
where s contains your string.
EDIT: the following would work as well..
regexp(s, '(?<=[^)]:).*(?=Start Date)', 'match')
..does anybody have a simpler pattern proposal?

更多回答（1 个）

Matt J
Matt J 2013-1-31
编辑：Matt J 2013-1-31

1 个投票

b='Manager of this associate';
e='Start Date';
ib=strfind(str,b);
ie=strfind(str,e);
str(ib+length(b):ie-1)

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by