topic Re: Isolate everything before space in QlikView

Isolate everything before space

gerhardl — Fri, 22 Mar 2013 10:20:08 GMT

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,

Gysbert_Wassenaar — Fri, 22 Mar 2013 10:23:49 GMT

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

gerhardl — Fri, 22 Mar 2013 10:26:50 GMT

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 — Fri, 22 Mar 2013 10:37:12 GMT

subfield(fieldname,' ',1) as name