Yes, you can do this in DataStage. This assumes you use a Sequence to get the filename or list of filenames and then you can process this to extract the date.
p.s. Please don't use ASAP in a post, it usually will cause any answers to be much slower. ASAP and URGENT are for paid services and usually carry quite a premium
HowToCheck Whether File contain today’s date in its name?
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the file name is a job parameter you can make this test in a simple expression if all you want to test for is "contains eight contiguous digits". If you want to check that they form a valid date then you will need a Routine.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
</a>