How to extract data from a srting?

Question

Vinay kumar Reddy 2013-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60642-how-to-extract-data-from-a-srting

采纳的回答： Cedric

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更早的评论

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 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.

请先登录，再进行评论。

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

Answer 1

Cedric 2013-1-31

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60642-how-to-extract-data-from-a-srting#answer_73110

编辑：Cedric 2013-2-1

在 MATLAB Online 中打开

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 个评论
显示 -1更早的评论隐藏 -1更早的评论

Vinay kumar Reddy 2013-2-1

Thanks!!! Cedric

That works great!!!

请先登录，再进行评论。

Answer 2

Matt J 2013-1-31

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/60642-how-to-extract-data-from-a-srting#answer_73018

编辑：Matt J 2013-1-31

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。