Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

RegEx Replace Function in Formula Tool

ZoeM
8 - Asteroid

Hello Community.

I have searched the blogs and posts to see if I can find an example for my situation, I want to wrap the text in one of the fields in my data set. I have 7 unique categories that I need the text wrapped before it feeds into the QVW data model and most posts are referencing using the RegEx Replace formula within the Formula Tool.

 

Could someone help me write the expression, and would I have to have 7 different expressions since I have 7 unique categories? 

 

Field Label - Content Issues

1. Lessons Learned - Constraints

2. Main Causal Factor - Primary

3. Strategic Metrics Health - Population

4. Program Health Review - Regional

5. Lack of Resources - Program

6. Timing Change - Program

7. Direction Change - Global

 

Any help is appreciated,

 

Thanks!

 

11 REPLIES 11
Claje
14 - Magnetar

Hi,

I think if only one word exists this replace function won't find a match.  If you change the configuration so that it copies unmatched text to output, I think it should handle this appropriately.

ZoeM
8 - Asteroid

Thanks for all the help!

Labels