Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
it-golestan
Creator II
Creator II

how to separate numbers after delimiter

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

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

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

or

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


regards
Pradosh

Learning never stops.

View solution in original post

3 Replies
kaushiknsolanki

Hi,

Try Subfield() function.

Load *,

Subfield(Fieldname,'/') as Newfield

From zyx;

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Anil_Babu_Samineni

What is the output u want to see?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Master II
Master II

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

or

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


regards
Pradosh

Learning never stops.

View solution in original post