Text Pre-possing tool not liking commas (,)

Question

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

replace Keyword from Name by Iteration.yxmd

aatalai · Answer

@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

akvsachin · Answer

Hi @aatalai ,

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