Last modified date: 20 Jul 2023
Environment
Tableau DesktopAnswer
Use the following regular expression in a calculated field:REGEXP_REPLACE([Num],'(\d{1,3}|\G\d{3})(?=(?:\d{3})+(?!\d))','$1.')
Note: Such a workaround will only work for data sources which allow regex functions.
Additional information
Use the attached sample workbook String example.twbx to view the calculated field in action.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