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?
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, ‘.’)
@rajab But, that Property1 may contain dot(.) or hyphen(-), it will not always be single character, will vary..!
@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