How to extract data from a srting?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Jan
el 31 de En. de 2013
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.
Respuesta aceptada
Cedric
el 31 de En. de 2013
Editada: Cedric
el 1 de Feb. de 2013
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?
Ver también
Categorías
Más información sobre File Operations en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!