Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
18 - Pollux
18 - Pollux

Happy to help @Meggan !

Labels
Top Solution Authors