Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
subfield(MyField,' ',1) will give you the string before the first space in the contents of MyField.
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
subfield(fieldname,' ',1) as name