Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
gerhardl
Creator II
Creator II

Isolate everything before space

Hi There,

In my load script, how can I identify everything in the field left of the first space character.

So I might have a name and surname in one field with a space in between, and it can be any number of characters, but I want to isolate just the name.

Thanks,

G

3 Replies
Gysbert_Wassenaar

subfield(MyField,' ',1) will give you the string before the first space in the contents of MyField.


talk is cheap, supply exceeds demand
gerhardl
Creator II
Creator II
Author

Sorry I founf another post explaining this and then un-marked mine as a question - not I can't mark your answer as correct.

But that works perfectly, thanks

er_mohit
Master II
Master II

subfield(fieldname,' ',1) as name