Struggling to find multiline content in a SWIFT message using regex

Question

Struggling to find multiline content in a SWIFT message using regex

Looking into a SWIFT message using RegEx, here is an excerpt:

:16R:FIN
:35B:ISIN CH0117044708
ANTEILE -DT USD- SWISSCANTO (CH)
INDEX EQUITY FUND USA
:16R:FIA

The goal is to extract information in group 3:

ISIN CH0117044708
ANTEILE -DT USD- SWISSCANTO (CH)
INDEX FUND V - SWISSCANTO (CH)
INDEX EQUITY FUND USA

However, only ISIN CH0117044708 is being captured.

Currently troubleshooting the RegEx issue with this expression:

/:([0-9]{2}[A-Z]){1}(::|:)((.*\r\n){1,4}|.*)/gm

To experiment further, check out this link: https://regex101.com/r/qX9cET/2

Edit: Exploring how to match this optional pattern:

([A-Z]*)(?:\/\/)?(.*(?:\/)?){0,2}

No // and / in line
// and a single /
// and two /

Incorporated in the previous example (https://regex101.com/r/Ubci69/5):

:16R:FIN
:97A::SAFE//0123-456789-11-020
:35B:ISIN CH0117044708
ANTEILE -DT USD- SWISSCANTO (CH)
INDEX FUND V - SWISSCANTO (CH)
INDEX EQUITY FUND USA
:16R:FIA
:93B::AGGR//UNIT/0,117
:19A::HOLD//CHF237,15
:92B::EXCH//JPY/CHF/0,0087535442107

javascript regex multiline

Answer 1

Answer №1

To capture in the third group, consider using [\s\S] instead of the dot to include whitespace characters and a negative lookahead (?! to ensure that what follows does not match :[0-9]{2}[A-Z]:{1,2} which is the initial pattern being sought.

You can also remove {1} if unnecessary and skip the first two capturing groups to centralize your values in just the first group.

:([0-9]{2}[A-Z])(::|:)((?:[\s\S](?!:[0-9]{2}[A-Z]:))*)

Check out this Regex Demo

Explanation

:: Matches literally
([0-9]{2}[A-Z]): Captures 2 digits followed by an uppercase character in the first group
(::|:): Captures two or one colon(s) in the second group
(: Starts the third group
- (?:: Non-capturing group
  - [\s\S]: Matches any character, including whitespaces
  - (?!:: Negative lookahead to ensure it doesn't match
    - [0-9]{2}[A-Z]:: Captures 2 digits followed by an uppercase letter and a colon in the first group
  - ): Closes the negative lookahead
- )*: Closes non-capturing group and repeats zero or more times
): Closes the third group

Update: A more optimized version of the above regex utilizing the dot. This will match the specified pattern with colons at the beginning, then proceed to match any characters until the end of the line with the option of encountering a line break. It uses a negative lookahead to ensure exclusion of the colon part, repeating the whole line in a continuous pattern.

:([0-9]{2}[A-Z])(::|:)(.*(?:\r?\n)?(?:(?!:[0-9]{2}[A-Z]:).*(?:\r?\n)?)*)

See this Regex demo for reference

Answer 2

To capture in the third group, consider using [\s\S] instead of the dot to include whitespace characters and a negative lookahead (?! to ensure that what follows does not match :[0-9]{2}[A-Z]:{1,2} which is the initial pattern being sought.

You can also remove {1} if unnecessary and skip the first two capturing groups to centralize your values in just the first group.

:([0-9]{2}[A-Z])(::|:)((?:[\s\S](?!:[0-9]{2}[A-Z]:))*)

Check out this Regex Demo

Explanation

:: Matches literally
([0-9]{2}[A-Z]): Captures 2 digits followed by an uppercase character in the first group
(::|:): Captures two or one colon(s) in the second group
(: Starts the third group
- (?:: Non-capturing group
  - [\s\S]: Matches any character, including whitespaces
  - (?!:: Negative lookahead to ensure it doesn't match
    - [0-9]{2}[A-Z]:: Captures 2 digits followed by an uppercase letter and a colon in the first group
  - ): Closes the negative lookahead
- )*: Closes non-capturing group and repeats zero or more times
): Closes the third group

Update: A more optimized version of the above regex utilizing the dot. This will match the specified pattern with colons at the beginning, then proceed to match any characters until the end of the line with the option of encountering a line break. It uses a negative lookahead to ensure exclusion of the colon part, repeating the whole line in a continuous pattern.

:([0-9]{2}[A-Z])(::|:)(.*(?:\r?\n)?(?:(?!:[0-9]{2}[A-Z]:).*(?:\r?\n)?)*)

See this Regex demo for reference

Struggling to find multiline content in a SWIFT message using regex

Answer №1

Similar questions

Avoid displaying passwords in source code

Adding jQuery and other libraries to Typescript for optimal functionality

The res.download() function is not functioning properly when called from within a function, yet it works perfectly when directly called through the API in a browser

reveal a hidden div by sliding it during an onclick action

Validating HTML using EJS templates set as "text/template" elements

Exploring Parquet Files with Node.js

Is there a way to temporarily toggle classes with jQuery?

Validation of New Relic License Key

Error: Unable to access undefined properties (reading 'url')

Error: The "toString" property of an undefined variable cannot be read in uploadify

Tips for moving and filling data in a different component using NextJS

The placement of the Vuetify tooltip is incorrectly aligned when located in the footer section

Slider Volume with jQuery

A proposal for implementing constructor parameter properties in ECMAScript

Removing all Null Form Inputs from the Document Object Model upon Submission utilizing JavaScript

Tips for integrating the react-financial-charts library into your React and JavaScript project

Implementing custom CSS styles to a component in real-time with ng-style

Tips for deactivating all JavaScript events on a webpage that has been loaded within an iframe

Verify the validation of the text box

AngularJS application is throwing an error indicating provider $q is not recognized