topic Re: text function in QlikView

text function

arsenal1983 — Tue, 27 Jun 2017 10:29:13 GMT

Hello,

In my data I have one string column. The data in this column can have several slash marks '/'. I need to extract the text between second and third slash mark.

Examplne

SURCE_DATA	EXTRACT
23/213123/3213213	213123
qww/12/01	12
p/000001/1	1

Re: text function

Frank_Hartmann — Tue, 27 Jun 2017 10:33:28 GMT

num(subfield(SURCE_DATA,'/',2)) as SURCE_DATA_New

hope this helps

Re: text function

qlikview979 — Tue, 27 Jun 2017 10:34:08 GMT

subfield(SURCE_DATA,'/',2) as EXTRACT

It will give result like

213123

Re: text function

sujeetsingh — Tue, 27 Jun 2017 10:38:17 GMT

Subfield is the best function to achieve this.