topic Re: String functions help in QlikView

String functions help

Mon, 11 May 2015 12:05:42 GMT

Hi All,

Is it possible to read the last two words of a string as a field?

e.g if the string is ABC DEF GHI.xls, then DEF GHI should be stored in a field.

Thanks,

Asma

Re: String functions help

sunny_talwar — Mon, 11 May 2015 12:16:10 GMT

You can try this may be:

=SubField('ABC DEF GHI', ' ', 2) & ' ' & SubField('ABC DEF GHI', ' ', 3)

Re: String functions help

ganeshreddy — Mon, 11 May 2015 12:16:20 GMT

Hi Asma,

try

right('ABC DEF GHI',7) as NewField,

and PFA

Cheers,

Ganesh.

Re: String functions help

MarcoWedel — Mon, 11 May 2015 12:57:21 GMT

Mid(string,Index(string,' ', -2)+1) as NewField

Re: String functions help

mohammadkhatimi — Mon, 11 May 2015 13:01:39 GMT

Hie..

SubField(trim(field name),' ',2)&''&SubField(trim(field name),' ',3)

Hope this will help you...

Regards,

Mohammad

Re: String functions help

sunilkumarqv — Mon, 11 May 2015 13:06:51 GMT

right(string,Index(string,' ', 2)) as NewField

Re: String functions help

Mon, 11 May 2015 13:07:26 GMT

Hi Asma,

for a field with an variable number of words in it, the below should work for you (a simple subfield 2 & 3 wouldn't work with a 4 word value )

subfield('ABC DEF GHI JKL', ' ',SubStringCount('ABC DEF GHI JKL',' ')) & ' ' &

subfield('ABC DEF GHI JKL', ' ',SubStringCount('ABC DEF GHI JKL',' ')+1)

hope that helps

Joe

Re: String functions help

Mon, 11 May 2015 14:18:36 GMT

you can also try this: Mid('ABC DEF GHI',FindOneOf('ABC DEF GHI',' *')) as new field;

See below instructions on how to add to script editor

in the script editor add this:

load

Mid(F1,FindOneOf(F1,' *')) as F2;

LOAD * INLINE [

ABC DEF GHI

];