Extract Specific String ... - Qlik Community

Report Inappropriate Content · ‎2012-12-10

Hi All,

1) I have a fied "Country" with values as

My output should be as follows

Appreciate help on this ...

Report Inappropriate Content · ‎2012-12-10

you can use subfield(Country, ' ',2)

Report Inappropriate Content · ‎2012-12-10

You can also use

=Right(Name,Len(Name)-8)

if they are all in the same format.

Report Inappropriate Content · ‎2012-12-10

With Name as your field name of course.

MayilVahanan · ‎2012-12-10

Hi

Try like this

subfield(Country, ' ',2)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

sujeetsingh · ‎2012-12-11

Good replies

!!!!!