Excel like ASC Function

steve_tang

Hi,

Is there a similar function in alteryx that can convert full-width (double-byte) characters to half-width (single-byte) characters like the ASC function in Excel?

For example,    "ＡＢＣＤＥ" (double-byte)  will be converted to "ABCDE"(single-byte).

I have tried some of the conversion functions but it does not work.

Sample Data.xlsx

danilang

Hi @steve_tang 

@rafalolbert's solution looks like the way to proceed, but I think that you need to parse your data on a character by character basis.  

The formula that I used is this.  

if ChartoInt([Original]) >65535-256 then
	ConvertFromCodePage([Original], 936)
else
	[Original]
endif

Only apply the code page conversion if the value of the character is > (65535 - 256). I looked, unsuccessfully, for a reference that shows the unicode range for double wide characters.  I chose the top 256 of the range because it fit the sample you provided.  You may have to adjust the 256 to fit your data.  If you do manage to find the actual range, please post it back here.

Results

The middle columns is the result of applying the conversion to all characters.  The last column uses the formula from above.

Dan

ASC.yxmd