Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
thierrytt
Contributor

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

Tags (3)
1 Solution

Accepted Solutions

Re: Pick up value from value separated by "/"

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

2 Replies

Re: Pick up value from value separated by "/"

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

thierrytt
Contributor

Pick up value from value separated by "/"

Great ! (and powerful!)

Thx

Community Browser