Folder stage Pattern

[shrinivas]

Hi Guys ,

I am facing one issue while using Folder stage to read a particular pattern files .I am explaining my problem with an example .

I have two files of pattern ABC_MMDDYY and ABC_DEF_MMDDYY.
What I need is I have to pick all the files with pattern ABC_MMDDYY . SO what i did in the folder stage I gave the pattern as ABC_*.But its reading all the files including files with pattern ABC_DEF_MMDDYY.

How can read the files only with pattern ABC_MMDDYY.

Any help is appreciated.

[kondeti]

Try to read the file in this way ABC_MMDDYY*

[mdan]

Try to read the file in this way ABC_MMDDYY*

Pattern ABC_* matches both types of files.
Create two different folders, one for each file family: f_def_mmddyy and f_mmddyy and place the files accordingly.

[chulett]

What kind of values are in the "_DEF_" portion of the filenames you want to avoid? Not sure how to do this on Windows, but if "DEF" is always character data, then something like this on a UNIX system would work:

Code: Select all

ABC_[0-9]*

You could also use '?' rather than '*' to specify a maximum number of character matches:

Code: Select all

ABC_??????

The "_DEF_" files would be 'too long' to match that pattern.

[JoshGeorge]

I don't think Folder stage will match the pattern the way you want with ABC_[0-9]* or ABC_?????? in Unix environment also. Help document for folder stage says you can use * or 3 dots (...) for pattern matching. I think, an operating system command is not really what the stage is expecting. Be glad to be proven wrong, however!

[chulett]

Interesting... to be perfectly honest, all I've ever needed to use was a splat so just made an assumption that it was doing O/S pattern matching. You're right, the help notes only the use of '*' and '...' which implies Universe pattern matching, or so it seems to me.

Anyone done anything other than straight '*' pattern matching in the Folder stage?

[shrinivas]

So is that mean there is no other way ..

[chulett]

Did you try any of the options given to see what happens? Verified that indeed they are not an option?