Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
FullName:
LOAD * inline [
Name
'Dave Owen'
'Joe Tem'
];
SepNames:
Load Name,
SubField(Name, ' ',1) as FirstName,
SubField(Name, ' ',-1) as Surname
Resident FullName;
Drop Table FullName;
i am pretty confused at field numbers,in above script field number are 1 and -1,can anyone please give me a clarification on this.
So subfield 1 is first from the left and subfield -1 is first from the right.
So subfield 1 is first from the left and subfield -1 is first from the right.