Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Keep values after first blank space

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!

1 Solution

Accepted Solutions

Re: Keep values after first blank space

Try this:

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

5 Replies

Re: Keep values after first blank space

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

Try with

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

marcus_malinow
Valued Contributor III

Re: Keep values after first blank space

This should work

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

Partner
Partner

Re: Keep values after first blank space

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);
Not applicable

Re: Keep values after first blank space

Perfect!

Thank You all for the answers.