Power BI

Needs Votes

ASC function to M for converting Zen Chars to Han Chars

Vote (87)

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 (6)

Comments (6)

on 05 Aug 2021 06:56:11

RE: ASC function to M for converting Zen Chars to Han Chars

I agree too. It is essential for data processing in 2-byte code language areas.

Toshik on 06 Jul 2020 00:15:26

RE: ASC function to M for converting Zen Chars to Han Chars

NEED it.

Power BI User on 06 Jul 2020 00:06:53

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.

Ryohei Yoshijima on 05 Jul 2020 22:35:04

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.

Kawabata Yoshihiro on 05 Jul 2020 22:33:36

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 関数と同じ機能を、増やしてほしい。

Shigeru Numaguchi on 05 Jul 2020 22:33:35

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.