Solved: Re: how to separate numbers after delimiter - Qlik Community

Anonymous · ‎2017-12-23

hi everyone

i want to separate numbers after second / in bellow example

1987/11/2

or

1987/11/12

i would appreciate if anyone can help

pradosh_thakur · ‎2017-12-23

=SubField('1987/11/12,'/',-1)

or

=subfield(Your_field,'/',-1)

regards
Pradosh

Learning never stops.

View solution in original post

kaushiknsolanki · ‎2017-12-23

Hi,

Try Subfield() function.

Load *,

Subfield(Fieldname,'/') as Newfield

From zyx;

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anil_Babu_Samineni · ‎2017-12-23

What is the output u want to see?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

pradosh_thakur · ‎2017-12-23

=SubField('1987/11/12,'/',-1)

or

=subfield(Your_field,'/',-1)

regards
Pradosh

Learning never stops.