Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

Subfiled( field_no)

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.

 

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

  • 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.

View solution in original post

1 Reply
Lisa_P
Employee
Employee

  • 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.