ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportRegular Expression in File name patterns

Post new topicReply to topic
Regular Expression in File name patterns View previous topic :: View next topic
Author Message
anil kumar
PostPosted: Wed Nov 15, 2017 4:36 am Post subject: Regular Expression in File name patterns Reply with quote

Apprentice

Joined: 22 Jan 2017
Posts: 36

Hi All,
Im trying to pick files from a local directory using a file input

my scenario is something like this
i want to read two files with two different naming convetions using single file input node
example:
i want to read two files using single file
file names :
viewfile_15112017.xml
makefile_15112017.xml


what i have tried and learnt from info center is


we can do this using ? wild card as ????file*.xml which can read the both file from the directory
but in future if any new files comes into the directory like editfile_15112017.xml it will pick that file aslo.

i thought of exculding that editfile_15112017.xml filename pattern in fileexclusion pattern but we can only ignore single file not multiple file name patterns

can any one has any solution for this
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Thu Nov 16, 2017 1:01 am Post subject: Reply with quote

Novice

Joined: 17 Jul 2017
Posts: 21
Location: UK

Hi Anil...can't you provide a file exclusion pattern (eg:- editfile*.xml) if your intention is to exclude all xml file starting with editfile
Back to top
View user's profile Send private message
anil kumar
PostPosted: Thu Nov 16, 2017 1:12 am Post subject: Reply with quote

Apprentice

Joined: 22 Jan 2017
Posts: 36

Hi ABHI...
yup you are correct we can ignore on file pattern as edit*.xml but if in case in future a new file comes into the folder with same 4 characters of intialname then we can not ignore that.

over all
my point is that how can we specify two different file name patterns on a single file input node . all i want to know is there a way to do that other than wildcard character ?
please suggest
Back to top
View user's profile Send private message
Vitor
PostPosted: Thu Nov 16, 2017 6:07 am Post subject: Re: Regular Expression in File name patterns Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 24648
Location: Ohio, USA

anil kumar wrote:
i want to read two files with two different naming convetions using single file input node


Why? What's the problem with a flow that has 2 FileInput nodes?
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
anil kumar
PostPosted: Thu Nov 16, 2017 10:53 pm Post subject: Reply with quote

Apprentice

Joined: 22 Jan 2017
Posts: 36

Hi Vitor,
we have two differnet flows polling the same SFTP server(same directory) with Two different file name patterns.
they are facing issues due to our continuous poling (now 5 seconds)
we want to integrate them into a single flow using single file input node want to read two files(two files of different name pattern). using single file input and then do our logic
is this possible to specify two different name patterns on the File input node
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Fri Nov 17, 2017 12:38 am Post subject: Reply with quote

Novice

Joined: 17 Jul 2017
Posts: 21
Location: UK

From what I know it is not possible to provide multiple file name patterns for the FileInput node...your original approach of having two flows searching for different file patterns against the same directory should work fine.

'they are facing issues due to our continuous poling'...can you please elaborate on the exact issue you are seeing?
Back to top
View user's profile Send private message
zpat
PostPosted: Fri Nov 17, 2017 12:42 am Post subject: Reply with quote

Jedi Council

Joined: 19 May 2001
Posts: 5578
Location: UK

You can have two (or more) fileinput nodes in the same flow - just join them both to the next node in the flow (under the covers this does run two threads).

You can increase the file scan interval to reduce the load on the file server.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error.


Last edited by zpat on Fri Nov 17, 2017 1:29 am; edited 1 time in total
Back to top
View user's profile Send private message
anil kumar
PostPosted: Fri Nov 17, 2017 12:55 am Post subject: Reply with quote

Apprentice

Joined: 22 Jan 2017
Posts: 36

Thanks Guys,
so it is clear we can not give two different file name patterns on the single file input node.
don't know the exact issue but they said they are seeing issues.
Thanks For all your Quick answers and support
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportRegular Expression in File name patterns
Jump to:



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.