cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
MathStatChem
Level VI

Column Formula to convert Unicode to symbol

I want to make JMP table that will have a column with the unicode shortcut for a symbol and then have JMP display the symbol (wiht a formula) in another column.  In the screen shot below, I would like the column Displayed to have formula that uses the column Unicode as an input and that shows the displayed symbol result.

 

The table below was created by manually typing the Alt+Code.

 

I can't figure out how to do that in a column formula. Any help would be appreciated

 

MathStatChem_0-1607352422640.png

 

15 REPLIES 15
lala
Level VII

回复: +Re: Column Formula to convert Unicode to symbol

Thank Craige!

  • The expert's method is incredibly fast!

lala
Level VII

回复: +Re: Column Formula to convert Unicode to symbol

Is there a better way to organize this form? I sincerely ask for expert help and guidance.

https://community.jmp.com/t5/Discussions/How-to-organize-this-non-standard-form/m-p/754705#M93693 

https://community.jmp.com/t5/Discussions/How-to-organize-this-non-standard-form/m-p/754705#M93693

Thank Craige!

lala
Level VII

回复: +Re: Column Formula to convert Unicode to symbol

How to quickly implement this Unicode lookup using JSL?

That is, I give a character Ώ and want to see how it is qualified in Unicode

 

Thanks Experts!

Craige_Hales
Super User

回复: +Re: Column Formula to convert Unicode to symbol

Fascinating, learned something I didn't expect:

c = "Ώ"; // the test character

table = [=> ]; // build the complete lookup table 1..FFFF
For( i = 1, i <= 65535, i += 1,
	code = Hex( i, "integer", padto( 4 ) ); // 0001 ... FFFF
	char = Blob To Char( Matrix To Blob( J( 1, 1, i ), "uint", 2, "little" ), "utf-16le" );
	If( !(table << Contains( char )),
		table[char] = {}; // make a list to hold extra codes for the same character
	);
	Insert Into( table[char], code ); // add character to the list
);

lookup = table[c]; // get the codes for the test character

For( i = 1, i <= N Items( lookup ), i += 1,
	// I don't know anything about this site, but it does retrieve the two characters 4jun2024
	Web( "https://www.compart.com/en/unicode/U+" || lookup[i] ); // open a web page for each character in the list
);

That's a brute force solution, but I'm not sure how else to do it! @hecht_jmp 

Two different Unicode characters are the same code point.Two different Unicode characters are the same code point.

Craige
lala
Level VII

回复: +Re: Column Formula to convert Unicode to symbol

  • I learned new skills from Craige's code every time.

Thank Craige!

lala
Level VII

回复: +Re: Column Formula to convert Unicode to symbol

  • There are functions available in excel

  • 2024-06-07_10-04-32.png20240607104451.png