inserting a file name into a table

• sandra pastrana

  SSC Eights!

  Points: 979

  More actions

  September 9, 2008 at 8:06 am

  #192632

  I have the following conditions:

  1.I have a flat file that lists some order numbers

  2. I have a folder with a file per order

  3.I need to find the file correspomding to the order number on the flat file.

  the order number is part of the file name

  4.after I have the file corresponding to the order, I wish to insert the file name and path into a table

  The problem is that i don't want to insert all of the file names into my table because the folder will never be purged and it will get to be very big.

  Any ideas on how to do that?

  I will really appreciate it.

• sandra pastrana

  SSC Eights!

  Points: 979

  More actions

  September 9, 2008 at 11:05 am

  #869178

  I got it.

  I did a forech loop container to loop through the files of the directory.

  so selected for each file enumerator

  selected the folder

  and for the file name created an expression

  filespec "*" + @[User::MyOrderVariable]+"*.*"