Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
SubField() string function will do:
SubField(Value, '/', 1) AS Value1,SubField(Value, '/', 2) AS Value2,
SubField(Value, '/', 1) AS Value1,
SubField(Value, '/', 2) AS Value2,
Hope that helps.
Miguel Angel Baeyens
Comex Grupo Ibérica
Great ! (and powerful!)