Test a routing pattern against real file names
Paste the file name pattern from a routing channel template or routing rule, and the names your partners actually send. You see which ones match, which facts each group extracts, and why the others don't.
Runs entirely in your browser. Nothing you paste is uploaded or stored, and the page's security policy blocks every network request.
One file name per line. Paste a directory listing or a column from a report; spaces inside names are kept.
Results
Questions
Which pattern syntax does Sterling use?
File Gateway routing channel templates take the file name pattern as a Java regular expression, with an optional comma-separated list of group fact names. Many adapter, mailbox and file system filters use simple wildcards instead, where * means any characters and ? means one character. Pick the mode that matches the field you are filling in.
How do group fact names work?
Each capturing group (...) in the pattern produces a value, in order. The first fact name gets the first group, the second name the second group, and so on. Use (?:...) for groups that only exist for alternation, so they don't shift the numbering. Berth shows the fact each group would produce for every matching file.
Does this behave exactly like Java?
The browser's regular expressions are close to Java's, and Berth translates the Java-only parts: \Q...\E quoting, a leading (?i), POSIX classes such as \p{Alpha}, and anchors such as \A and \z. Where Java would reject a pattern, for example an unescaped { or a lookbehind without a maximum length, Berth says so. Possessive quantifiers and atomic groups are run as ordinary ones, with a warning.
Whole name or find?
With "Whole file name must match" on, the pattern has to cover the entire name, like Java's matches(). Off, it only has to occur somewhere in the name, like find(). When a name misses only because of this, or only because of upper and lower case, Berth tells you.
Who makes this?
Berth is built by Myggiz Software B.V. in the Netherlands, by an integration consultant with 30 years of B2B integration work, Sterling B2B Integrator included. It is one of the free Munetris tools for teams running B2B gateways, along with the certificate checker and the XPath tester.