topic load only last 2 words from a field in QlikView

load only last 2 words from a field

Tue, 06 Jul 2010 20:18:27 GMT

I'm building a demo app from client data and they're asking me to only show a portion of each project name in the app. For example, if a project name is shown as "Help the Homeless in DC", they want to only show "in DC" so as to not give away the source of the data. I can easily right-trim the data but it looks kind of messy so my preference is to grab only the last 2-3 words of the project name. Thoughts?

Thanks,

Kevin

load only last 2 words from a field

Tue, 06 Jul 2010 21:27:25 GMT

Subfield could work although you would need to know how many words you have or setup a sount of the delimiter (space in this case), try:

subfield(projectname,' ',4)&" "&subfield(projectname,' ',5)& as ShortName,

in your load script (assuming your project name field is 'projectname'

load only last 2 words from a field

pbaenen — Tue, 06 Jul 2010 21:36:14 GMT

You can use substringcount to figure out how many fields you have.

subfield(vMyField, ' ', substringcount(vMyField, ' '))
& ' ' &
subfield(vMyField, ' ', substringcount(vMyField, ' ')+1);

load only last 2 words from a field

hector — Tue, 06 Jul 2010 21:47:52 GMT

Hi, this is a little test, maybe it will work for your needs

rgds

load only last 2 words from a field

rwunderlich — Tue, 06 Jul 2010 23:17:14 GMT

You can use subfield with a negative index to extract words from the end of the full name.

subfield(project, ' ', -2) & ' ' & subfield(project, ' ', -1) as ShortName

-Rob