Subfiled( field_no)

[venkat1]

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.

[Lisa_P · Accepted solution]

• If field_no is a positive value, substrings are extracted from left to right.
• If field_no is a negative value, substrings are extracted from right to left.

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