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