Keep values after first blank space

[#1]

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!

[sunny_talwar · Accepted solution]

Try this:

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

[alexandros17]

Try with

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

[marcus_malinow]

This should work

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

[elyM]

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

[#6]

Perfect!

Thank You all for the answers.