Kawabata Yoshihiro on 20 Apr 2016 17:20:13
I want to converting Zen chars to Han chars in Japanese Text.
A lot of Government Data us number as Zen chars, which can not converting data type from text to number in M language.
- Comments (5)
RE: ASC function to M for converting Zen Chars to Han Chars
NEED it.
RE: ASC function to M for converting Zen Chars to Han Chars
Also other 2-byte code languages such as Chinese, Korean etc... have the same problem.
The "１" (2-byte "1") treats as Text type.
We need the "ASC () " function of Excel.
RE: ASC function to M for converting Zen Chars to Han Chars
100% Agree, this requirement is appropriate and necessary to fabricate double bytes data into sigle byte smoothly, pls improve this area. High Priority from Japan.
RE: ASC function to M for converting Zen Chars to Han Chars
'This Idea : Japanese version.
---
全角文字から、半角文字へ変える関数が、M 言語に欲しい.
日本政府のExcel ファイルのデータは、数字に、全角文字を使っていることがあります。
数字の全角文字を、M 言語は、数値として扱えません。
Excel は、ASC 関数が、全角文字から半角文字へ変えられます。
Power BI の M 言語に、Excel の ASC 関数と同じ機能を、増やしてほしい。
RE: ASC function to M for converting Zen Chars to Han Chars
Japanese Excel has this worksheet function - ASC. As ETL tool, we should have this translation function in Power Query / PBI Desktop.