With regular expressions certain sections of column values can be identified via a combination of signs.
The values in column Standards number consist of complex expressions (e.g. “xyz DIN 174jdfjd”). Within these strings the expressions for Standards numbers used in PARTdataManager tables (“DIN 174”) are to be found. To compare column values of text file and table, the relevant expressions must be extracted from the strings.
So you filter the following string: “DIN“, followed by a blank and a number. The number consists of the digits 0 to 9, which can occur any often in this number.
Used Symbol in correspondence with regular expressions:
The following examples are based on character string ABCXYZDEF