Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Parsing specific filters from String

samxhander09
8 - Asteroid

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

 

3 REPLIES 3
aatalai
15 - Aurora

 

 

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

aatalai
15 - Aurora

that will parse it and then use filter

binuacs
21 - Polaris

@samxhander09 one way of doing this

image.png

Labels
Top Solution Authors