Alteryx Designer Desktop Discussions

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

Need help in Regex_Replace formula not Regex tool

RajatRehria
8 - Asteroid

Hi Guys, I hope u all doing well.

 

I have a text as |Dividend income|66|25|78|1,256|361 and I want how can i get the values till second pipe from the end using Regex_Replace formula only (not via Regex tool),

required output is |1,256|361 please help with the Regex formula. Thanks.

10 REPLIES 10
alexnajm
17 - Castor
17 - Castor

Happy to help @Meggan !

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels