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

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


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


Tableau Desktop
Tableau Prep Builder


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?