Subfield

[renuka_sasikumar]

Name

Parvinder Kaur

John P Gonsalve

Ritesh Gupta

Anita G Rodrigues

Deepali R Jahav

Rupesh J Sonawane

Fatima C Fernandes

Sunil S Singh

Rohit J Gupta

How do I remove the middle name and display the First Name n Last Name.

[Jason_Michaelides]

Make sure you mark a correct answer to close the thread.

[#3]

hi

try according to

Sir hic

subfield(Name, ' ' ,1) & ' ' & subfield(Name, ' ' ,-1) As Name

Regards

[#4]

I always refresh before replying to a post - so that I know that nobody before me has given a better answer . I think the QlikView team should include / improve AJAX for this forum as well so that things get updated live.

[MK_QSL]

This is because sometimes members are replying to selecting reply of some other members rather than selecting the original post.

[Jason_Michaelides]

Still not sure why those responses didn't show either before or after I posted a reply. After refreshing my response was third on the list. Anyway - as I say - not a big deal. As long as a helpful answer is received!!

[#7]

How about this? It works for the names without a middle name as well.

if(len(SubField(GetFieldSelections(Name),' ',2))=1, Replace(GetFieldSelections(Name),' ' & SubField(GetFieldSelections(Name),' ',2) &' ',' '), GetFieldSelections(Name))

[renuka_sasikumar]

I m new to qlikview n i think this is too confusing

[sunilkumarqv]

Like these

Please find the attached file you may see desired result

[renuka_sasikumar]

this is also working

Thank u