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
Solved! Go to Solution.
(ARGR DEPOSIT\s.{2})(\s(.{4}\sDistrict Branch)\sORIGINAL AMOUNT.*
that will parse it and then use filter
@samxhander09 one way of doing this