KNOWLEDGE BASE

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


Published: 07 Feb 2024
Last Modified Date: 08 Feb 2024

Question

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

Environment

Tableau Desktop
Tableau Prep Builder

Answer

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
Did this article resolve the issue?