topic Re: Keep values after first blank space in QlikView

Keep values after first blank space

Tue, 21 Jul 2015 15:35:40 GMT

Hello,

I want to keep all the values of a field after the first space, no matter how many there are.
I know how to extract the first value using subfield(FIELD, ' ', 1).

But I really have no ideia how to keep all the values AFTER.

I have: A B C D and so on.

I want: B C D and so on.

Thank You!

Re: Keep values after first blank space

sunny_talwar — Tue, 21 Jul 2015 15:45:26 GMT

Try this:

=Right('A B C D', Len('A B C D') - Index('A B C D', ' ', 1))

Re: Keep values after first blank space

alexandros17 — Tue, 21 Jul 2015 15:46:24 GMT

Try with

=Mid('A B C D', Index('A B C D', ' ', 1))

Re: Keep values after first blank space

marcus_malinow — Tue, 21 Jul 2015 15:47:02 GMT

This should work

Right(FIELD, Len(FIELD) - Index(FIELD, ' '))

Re: Keep values after first blank space

elyM — Tue, 21 Jul 2015 15:58:51 GMT

Hi Erick,

If you want to extract in Qlik script, you can follow this easy example.

Let vEmpty     =     '  EB TR fg h y     o ';

Tab:
Load
     FIELD
Where
     Trim(FIELD)<>'';
Load
     SubField('$(vEmpty)',' ')     AS FIELD
AutoGenerate(1);

Re: Keep values after first blank space

Tue, 21 Jul 2015 17:18:16 GMT

Perfect!

Thank You all for the answers.