Extract String from DB
Hi!
I am looking for a simple way to extract a string which looks like "SURNAME/GIVENNAME MR" to separate values.
The string is coming from my DB datasource an is currenctly recognized as property tbl.Name.
What wouls need is to have SURNAME GIVEN NAME and TITLE in separate properties.
I know there might be a way to do this with regular expression. Sadly I am not quite familiar at this time with groovy script.
Anyone give me an example how to manage this?
Brgs
iRoxter
I am looking for a simple way to extract a string which looks like "SURNAME/GIVENNAME MR" to separate values.
The string is coming from my DB datasource an is currenctly recognized as property tbl.Name.
What wouls need is to have SURNAME GIVEN NAME and TITLE in separate properties.
I know there might be a way to do this with regular expression. Sadly I am not quite familiar at this time with groovy script.
Anyone give me an example how to manage this?
Brgs
iRoxter