I am building a dynamic array, by reading a flatfile. My Flatfile will have the values like
Code: Select all
JOB1,Y,N
JOB2,N,N
JOB3,Y,Y
So my dynamic array will look like
Code: Select all
JOB1,Y,N:@AM:
JOB2,N,N:@AM:
JOB3,Y,Y:@AM:
So I am using Locate statement, as it will be Very fater than For ... Next loop, and i can avoid running loop for every job.
I am using the Locate Statement like
Code: Select all
Locate JobName IN JOBLIST Setting POS Then
JobSettings = Field(JOBLIST<POS>,",",2,2)
End Else
JobSettings = ""
End
How to achieve this with the Locate Statement itself?
Or is there I can change while building the dynamic array itself, because i am creating the dynamic array.