RegEx formula

I have the below transaction description, and I would like to use RegEx to only keep the bold portion. I have several line items with this layout, and cannot figure out how to delete the before and after words around the bold investment. For all line items, I'd like to delete everything prior to xxxxnumbers and after "TRN".

FUNDS WIRED TO:SVB, A DIVISION OF FIRST CITIZENS B ACCT: XXXX0000 3PM FAKE INVESTMENT CO TRN #2424210 PM FAKE INVESTMENT CO CAPITAL CALL

Workflow

Regex

Tips and Tricks

Parse

Accepted answers

binu_acs

@alexisdewaine

All comments

ccanterman

Hey! You'll want to use the Formula Tool with the RegEx_Replace formula. Instead of deleting the before and after, you'll keep the middle but putting it in ( ) and then putting $1 in the 3rd part of the clause, to indicate to return the 1st parenthesis'd clause

Replace "Before", "Keep", and "After", with your RegEx

RegEx_Replace([Field], "Before(Keep)After", "$1")

binu_acs

@alexisdewaine

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703