Dynamically Created Filename for ASCII pass

[Former Member]

A customer has an input file that changes names everyday due to the filename having the date and time in it.  I need to use this file as the input file in a From ASCII pass to load a table.  I can read an .INI file that will tell me what the file name is, so I created a pass to read that .INI file and populate a local job variable.

Is there a way I can use that local variable in the input file string.  I created a local constant %$Z_FILE_LOCATION% that points to the local drive folder and I created a local variable %$Z_DATA_FILE%.  If I right-mouse click in the It seems that if the value is in a local or global constant I can use it, but the local variable I can't seem to get.

Anyone have any suggestions?

Thanks,

ALJ

[terovirta · Accepted solution]

Something like this? A script that returns the filename from global or job constant or variable or elsewhere..

regards, Tero

[Former Member · Accepted solution]

Tero,

Using a function was my first thought, but I didn't pursue it because, I guess, I didn't think a function would work in that field.

Works perfectly,

Thanks sir!

ALJ