Pick up value from value separated by "/"

[thierrytt1102]

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

[Miguel_Angel_Baeyens · Accepted solution]

Hi Thierry,

SubField() string function will do:

SubField(Value, '/', 1) AS Value1,
SubField(Value, '/', 2) AS Value2,

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[thierrytt1102]

Great ! (and powerful!)

Thx