How to use values in a field as a variable

Mon, 24 Sep 2012 19:36:56 GMT

Dear All,

I have fetch the all foldernames with a macro from the ftp site. The name of the field is fileName and the content of it as below:

08012012

08062012

08132012

08272012

09032012

09102012

09172012

09242012

Now I want to use them as a variable in the path instead of XXXXX.

LOAD

FROM

(txt, codepage is 1254, no labels, delimiter is ',', msq) ;

How can I do that?

Kind Regards,

Re: How to use values in a field as a variable

Mon, 24 Sep 2012 23:10:12 GMT

You can try this might work

Step1 :While Loading the table consisitng of File Index Numbers , also load along with them the serial number using REC No() or RowNo() functions

Step2: Declare a Variable reffering to the path

Step3: Using For Next Loop and Peek Functions try to run