Text Filter Using Regular Expressions

The following describes how to use “regular expressions” to search for an “International Bank Account Number” [IBAN].

The German IBAN, for instance, is structured according to the following pattern:
DExx bbbb bbbb kkkk kkkk kk
(DE = Germany, x = check digits, b = bank code, k = account number)

In most countries, the country code is the only alphabetic code in the IBAN, but there are countries (e.g. France) where both the bank code and the account number may contain letters.

In this example, we shall assume that the bank code and the account number consist of digits only. Due to different rules, the length of the IBAN code ranges from 18 to 32 characters.

Step by Step:

1. Create an “iQ.Suite Utilities Dictionary” document

Picture: Dictonary-Document (Wall - Utilities -Dictonary)

Enter a category (here “Bank”), a weighting factor (here 1) and the regular expression (here [A-Za-z]{2}[0-9]{2}[0-9s]{11,30}).

1. Create a “Wall Mail Job Advanced” document

I: Under “Operations”, set the “preliminary” tools (unpackers/converters/text normalizers).

II: Select the analysis tool for regular expressions (Unicode Analyzer for Regular Expressions).

III: Select the email parts to be checked.

IV: Select the text list / dictionary previously created (“Bank” category) and set the threshold to define how many times the pattern needs to be found in the email.

The remaining settings are made in the usual way.

This job will now filter all emails that contain an IBAN code.

Refer to the excerpt from the iQ.Suite quarantine.