susiebrown
04-03-2008, 09:04 AM
Hi,
I need some help with automating a repetitive task. I need to import daily, files that have names that look like this:
"C:\Documents and Settings\Administrator\Desktop\teledraft\28345_243_20080402.csv"
The path is always consistent and the "_243_" is consistent and the date is always yesterdays date. The 28345 is a number that changes daily. I have managed to get everything including the date correct, but I can't seem to find a way to wild card the five digit number. I've tried * ? # and every combination of bracketing and quote marks imaginable, all to no avail. I'm sure there is a simple way to do this, I just can't seem to figure it out. Any assistance would be so greatly appreciated. Thank you in Advance!
Warmest regards,
Susie
I need some help with automating a repetitive task. I need to import daily, files that have names that look like this:
"C:\Documents and Settings\Administrator\Desktop\teledraft\28345_243_20080402.csv"
The path is always consistent and the "_243_" is consistent and the date is always yesterdays date. The 28345 is a number that changes daily. I have managed to get everything including the date correct, but I can't seem to find a way to wild card the five digit number. I've tried * ? # and every combination of bracketing and quote marks imaginable, all to no avail. I'm sure there is a simple way to do this, I just can't seem to figure it out. Any assistance would be so greatly appreciated. Thank you in Advance!
Warmest regards,
Susie