Solved: Re: Repeated Word in Field Value - Qlik Community

Anonymous · ‎2017-09-20

Hi ,

I am having Field As Full Name, in that name is displaying as 'Judy Crawford Crawford', In need to Remove the Crawford Name in the Field Value

Expected Result:

Full name:

Judy Crawford

kaushiknsolanki · ‎2017-09-20

If the word count is different and you want only first two words then try this.

Load SubField(Data,' ',1) &' '& SubField(Data,' ',2) as Newfield inline [

Data

Judy Crawford Crawford Crawford

];

Regards,

Kaushik Solanki

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

mostwanted123 · ‎2017-09-20

Try this,

=Subfield(FullName,' ',1) &' '&Subfield(FullName,' ',2)

Regards,

Pratik

kaushiknsolanki · ‎2017-09-20

Try this.

LOad Data,If(SubField(Data,' ',2) = SubField(Data,' ',3),SubField(Data,' ',1) &' '&SubField(Data,' ',2),Data) as NewField inline [

Data

Judy Crawford Crawford

ABC PQR

];

Regards,

Kaushik Solanki

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

antoniotiman · ‎2017-09-20

Left('Judy Crawford Crawford',Index('Judy Crawford Crawford',' ',-1))

Regards,

Antonio

Anonymous · ‎2017-09-20

It creating One more Duplicate word in Field Value

mostwanted123 · ‎2017-09-20

example ?

Anonymous · ‎2017-09-20

Judy Crawford Crawford Crawford

Anonymous · ‎2017-09-20

it is within the Field How can i do this

mostwanted123 · ‎2017-09-20

Can you share the expression that you have written ?

kaushiknsolanki · ‎2017-09-20

If the word count is different and you want only first two words then try this.

Load SubField(Data,' ',1) &' '& SubField(Data,' ',2) as Newfield inline [

Data

Judy Crawford Crawford Crawford

];

Regards,

Kaushik Solanki

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