text function

[arsenal1983]

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

[Frank_Hartmann · Accepted solution]

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

hope this helps

[qlikview979]

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

It will give result like

213123

12

1

[sujeetsingh]

Subfield is the best function to achieve this.