topic Re: Extract the last word in QlikView

Extract the last word

Tue, 27 Oct 2015 11:06:13 GMT

Hi Everyone !

I need to extract the last word in a field. Does a function exist to do that ?

Thanks,

Re: Extract the last word

lironbaram — Tue, 27 Oct 2015 14:22:16 GMT

something like

subfield(YOURFIELD,SubStringCount(YOURFIELD,' ')+1) as LastWord

should do the trick

Re: Extract the last word

sunny_talwar — Tue, 27 Oct 2015 14:28:01 GMT

SubField(Fieldname, ' ', -1) as LastWord

Re: Extract the last word

Tue, 27 Oct 2015 14:34:07 GMT

An error appears. It says "inadequate Object memory"

Re: Extract the last word

Tue, 27 Oct 2015 14:34:53 GMT

This expression gives me the last letter of the last word

Re: Extract the last word

sunny_talwar — Tue, 27 Oct 2015 16:02:16 GMT

Can you share an example of your input?

Re: Extract the last word

Tue, 27 Oct 2015 16:16:12 GMT

Example :

LOAD * INLINE [

Name, Full_Adress,

James, 3 rue Victor hugo 60100 CREIL,

Nick, 6 rue Lucien charton 60160 LAIGNEVILLE,

Lena, 9 rue Henri Breuil 60600 CLERMONT,

Jenny, 12 rue des frères grimm 60180 NOGENT]

I would like to extract the last word of Full_Adress which refers to the town.

I don't know how to join a Qlikview file here

Re: Extract the last word

Colin-Albert — Tue, 27 Oct 2015 16:27:22 GMT

Try this, it returns the last word OK for me.

Data:
LOAD
subfield(Full_Address, ' ', -1) as LastWord,
*
INLINE [
Name, Full_Address,
James, 3 rue Victor hugo 60100 CREIL,
Nick, 6 rue Lucien charton 60160 LAIGNEVILLE,
Lena, 9 rue Henri Breuil 60600 CLERMONT,
Jenny, 12 rue des frères grimm 60180 NOGENT
];

Re: Extract the last word

sunny_talwar — Tue, 27 Oct 2015 16:32:35 GMT

Yup, I don't see why it wouldn't work

Re: Extract the last word

rwunderlich — Tue, 27 Oct 2015 16:55:26 GMT

I believe Sunny T gave you the correct answer. But you did not code the space between ' '. It will work if you include the space.

-Rob

Re: Extract the last word

prabhu0505 — Tue, 27 Oct 2015 16:57:57 GMT

Solution suggested by Sunny and Colin works fine. Just added another way.

LOAD

subfield(Full_Address, ' ', -1) as LastWord,

Right(Full_Address, len( Full_Address ) -Index(Full_Address,' ', -1)) as LastWord1,

INLINE [

Name, Full_Address,

James, 3 rue Victor hugo 60100 CREIL,

Nick, 6 rue Lucien charton 60160 LAIGNEVILLE,

Lena, 9 rue Henri Breuil 60600 CLERMONT,

Jenny, 12 rue des frères grimm 60180 NOGENT

];

Re: Extract the last word

Wed, 28 Oct 2015 07:29:25 GMT

Thank You Everyone !