Reading File pattern

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
santhoshrao.kuttuva
Participant
Posts: 13
Joined: Tue May 12, 2009 6:22 am
Location: Chennai

Reading File pattern

Post by santhoshrao.kuttuva »

Hi all

In my source sequential stage properties I have specified Read method as File Pattern.

Whether I can specify the file pathname with any regular expressions.

For e.g., "X:\DS\sample.regular expression"

My actual file name will be like this "sample.20090405"


Please advice with some simple examples.. Thanks in advance..
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Short answer is "yes" and quickest way to test would be to try it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
santhoshrao.kuttuva
Participant
Posts: 13
Joined: Tue May 12, 2009 6:22 am
Location: Chennai

Post by santhoshrao.kuttuva »

chulett wrote:Short answer is "yes" and quickest way to test would be to try it. ...

yes, I tried specifying the file name as

"sample.(19|20)\d\d[- /.](0[1-9]|1[012])[- /.](0[1-9]|[12][0-9]|3[01])"

but i cant able to view the data... Please help
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ack... mea culpa... was thinking 'wildcards' when you said 'regular expressions'. Does that work from your O/S? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply