Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear,
I need to pick up 2 values from one which are separated by "/".
For example: value = 8585/89785
How can I split this value into:
Value1 = 8585
Value2 = 89785
I'd frist think to do this:
"*/" as Value1,
"/*' as Value2
But I don't see how to code... 😕
Thank you for your help guys.
T T
Hi Thierry,
SubField() string function will do:
SubField(Value, '/', 1) AS Value1,
SubField(Value, '/', 2) AS Value2,
Hope that helps.
BI Consultant
Hi Thierry,
SubField() string function will do:
SubField(Value, '/', 1) AS Value1,
SubField(Value, '/', 2) AS Value2,
Hope that helps.
BI Consultant
Great ! (and powerful!)
Thx