Parsing specific filters from String

[samxhander09]

Hi Community! I have a question about parsing specific data from a string, say I have the below strings:

ARGR DEPOSIT IN West District Branch ORIGINAL AMOUNT 34.00 USD REF# ACBDCP241234017 REMARK: ARGR Deposit by POM POM (123456789)

ARGR DEPOSIT IN East District Branch ORIGINAL AMOUNT 12.00 USD REF# ABC253P241110017 REMARK: ARGR Deposit by POM POM (000028373)

ARGR DEPOSIT AT South District Branch ORIGINAL AMOUNT 84.00 USD REF# POA3HDP123540017 REMARK: ARGR Deposit by POM POM (999283673)

How can I parse West/East/South District Branch using ARGR DEPOSIT IN/AT as a filter?

Desired Output:

West District Branch

East District Branch

South District Branch

[aatalai]

(ARGR DEPOSIT\s.{2})(\s(.{4}\sDistrict Branch)\sORIGINAL AMOUNT.*

[aatalai]

that will parse it and then use filter

[binuacs · Accepted solution]

@samxhander09 one way of doing this