Last Modified Date: 22 Mar 2023
Environment
- Tableau Prep Builder
Resolution
As a workaround, use REPLACE([<target field name>], "-", "") or REGEXP_REPLACE([<target field name>], '\p{Punct}','') instead of "Remove Punctuation".Cause
The cause of the issue is that Hive regex has a different expression for punctuations, "\p{Punct}" instead of the usual "[[:punct:]]".Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials