Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

Try this:

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

View solution in original post

5 Replies
sunny_talwar

Try this:

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

alexandros17
Partner - Champion III
Partner - Champion III

Try with

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

marcus_malinow
Partner - Specialist III
Partner - Specialist III

This should work

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

elyM
Partner - Creator
Partner - Creator

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
Author

Perfect!

Thank You all for the answers.