topic Subfield??? in QlikView

Subfield???

soha1902 — Tue, 31 Mar 2015 12:17:03 GMT

Hi All,

I am having one column which is having values like

A/B/C

B/C/D/A

A/B

Now my requirement is I want to create a new field with help of this field which contains all the values which comes after first '/' from left.

Expected field contains:

B/C

C/D/A

Thanks...

Anonymous — Tue, 31 Mar 2015 12:21:43 GMT

use subfield(yourstring, '/', 2) to get text right of first char /

Tue, 31 Mar 2015 12:24:29 GMT

Hi Soha,

try like this in scripting...

subfield(string, '/', 2) as "Your New fieldName"

MK_QSL — Tue, 31 Mar 2015 12:25:12 GMT

Load *, Mid(FIELD, Index(FIELD,'/',1)+1) as NEWFIELD Inline

[

FIELD

A/B/C

B/C/D/A

A/B

];

soha1902 — Tue, 31 Mar 2015 12:25:28 GMT

I dont want right most only. Please see expected fields.

Anonymous — Tue, 31 Mar 2015 12:29:31 GMT

right(yourstring,len(yourstring)-FindOneOf(yourstring,'/',1))