Hi,
I am importing some txt files from a folder which is created in Data Directory. This folder contains few txt files I have to upload to Lotus database.
My issue is that I don’t know the exact file name…e.g the File name is “H7292.TRWEEKD.D071216.T0105532”
In this, “H7292.TRWEEKD.D071216.T0105532” part is known but the last part “0105532” is dynamically generated.
Could you please help me importing this file with this info.
thanks in advance
-Rajni
Subject: If you know part of the file name, then you should be able to…
…retrieve a list of the correct files and process them.
Use the Dir$ command to retrieve the list, then process each file returned (presuming you may have more than one in the folder).
This is straight out of the Designer help (with a couple of slight mod’s for you)…
pathName$ = “c:\yourFolder\H7292.TRWEEKD.D071216.T0105532*.*”
fileName$ = Dir$(pathName$, 0)
Do While fileName$ <> “”
Print fileName$
fileName$ = Dir$()
Loop
Hope that helps,
T.
Subject: RE: If you know part of the file name, then you should be able to…
Thanks terry…that worked !