Subfiled( field_no)

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Subfiled( field_no)

Lisa_P — Thu, 08 Aug 2019 05:52:36 GMT

So subfield 1 is first from the left and subfield -1 is first from the right.