- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +Re: Column Formula to convert Unicode to symbol
Thank Craige!
The expert's method is incredibly fast!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +Re: Column Formula to convert Unicode to symbol
I learned new skills from Craige's code every time.
Thank Craige!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
回复: +Re: Column Formula to convert Unicode to symbol
There are functions available in excel
- « Previous
-
- 1
- 2
- Next »