Question
Evoke Technologies
US
Last activity: 12 Mar 2023 8:35 EDT
To get the required values
Lets say I have two properties, Property 1 & 2
and two expressions, abc:1234.23 & abc:1234-23 (anything may come)
Now there are two requirements, property 1 must hold the value after ":" & before "." or "-" i.e.,1234
Property 2 must hold the value after "." or "-", i.e, 23 How can I achieve this? How exactly can this be done with "whatcomes...." function?
***Edited by Moderator Marije to add Capability tags***
***Edited by Moderator Marissa to update Product***
Accepted Solution
Updated: 12 Mar 2023 8:35 EDT
Helaba
DE
@AkshithReddyT wouldn't you combine both as it will return the whole string if the split character is not found?
so: "after :" will get rid of the leading characters.
"before ." will return 1234 or 1234-23
and "before -" on that result will always return 1234.
same with: "after ." will return abc:1234-23 or 23 and "after -" on that result will then always return 23
Pegasystems Inc.
IN
You can leverage the OOTB function "WhatComesBeforeFirst" / "WhatComesAfterFirst". Pass the 2 parameters - Property holding the string, character with which you want to split the string. The function returns a string.
WhatComesBeforeFirst ( Property1, '.')
Accepted Solution
Updated: 12 Mar 2023 8:35 EDT
Helaba
DE
@AkshithReddyT wouldn't you combine both as it will return the whole string if the split character is not found?
so: "after :" will get rid of the leading characters.
"before ." will return 1234 or 1234-23
and "before -" on that result will always return 1234.
same with: "after ." will return abc:1234-23 or 23 and "after -" on that result will then always return 23