Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thierrytt1102
Partner - Creator II
Partner - Creator II

Pick up value from value separated by "/"

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

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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

View solution in original post

2 Replies
Miguel_Angel_Baeyens

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
Partner - Creator II
Partner - Creator II
Author

Great ! (and powerful!)

Thx