Is there any good way to change all half-width katakana to full-width in synapse?

NishimuraChinatsu-9854 756 Reputation points
2022-10-24T08:45:38.383+00:00

Is there a good way to convert Japanese half-width katakana characters in data to full-width characters using the synapse pipeline?
I want to unify the characters in the data.
I can do it in English, but I can't get it right in Japanese.

Half-width katakana is like ア イ ウ エ オ.
If I convert it to full-width, it becomes ア・イ・ウ・エ・オ.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 90,646 Reputation points Moderator
    2022-11-01T05:18:40.39+00:00

    Hello @NishimuraChinatsu-9854 ,

    You may try using the normalize() function in dataflows? This is what my output looks like when using that function.

    255903-image.png

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.