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
Hi @aatalai ,
Why don't you try a formula tool and keep it as [Name] = REGEX_Replace([Name], "(?i)\b(Inc|llc|Plc)\b|[.#]", "")
@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
User | Count |
---|---|
107 | |
85 | |
76 | |
54 | |
40 |