Loading
Salesforce now sends email only from verified domains. Read More

How to Work with Japanese Half-width and Full-width Characters

Publish Date: Mar 27, 2026
Task
How to use the CONTAINS function or a filter when both Japanese full-width and half-width characters are being used in the data.  For example, if there are full-width characters and half-width characters in the data and using the CONTAINS function,Tableau returns a FALSE result. 

User-added image
Steps
Please review the sample packaged workbook found in the Attachments section to review the solution below.

Adjust the CONTAINS function to set both half-width and full-width characters as demonstrated in the below screenshot.  

User-added image
Additional Resources

To voice your support for the inclusion of this feature in a future release, please vote on the Idea for Prep: Add cleaning options for Japanese character.

Knowledge Article Number

001470575

 
Loading
Salesforce Help | Article