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.

Text Pre-possing tool not liking commas (,)

aatalai
15 - Aurora

Hi all

 

Looking/experimenting with the text mining tools; looking at the text Pre-Proccessing tool to remove certain words. Works fine except for one case where the stopping name conatins a comma(,)

 

Input

123 .,#

 

stopping term 

.,#

 

Expected outcome

123

 

actual outcome 

123 . , #

 

I'm aware this can be done find and replace, just want to know if this can be done via the Text prepressing, can see that , and space is used for manual entires of stop works

Screenshot 2025-07-10 121820.png

 

2 REPLIES 2
akvsachin
8 - Asteroid

Hi @aatalai , 

 

Why don't you try a formula tool and keep it as [Name] = REGEX_Replace([Name], "(?i)\b(Inc|llc|Plc)\b|[.#]", "")

aatalai
15 - Aurora

@akvsachin thanks for your post aware that this could be done via find and replace or even regex_replace in the formula tool, however, I'm trying to explore the text mininig tools and see if it could be done in that

Labels
Top Solution Authors