nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find a faster way.

lwx228

With "Big Class.jmp"
Extract the first, second, and last character of each row "name" column .
These characters are matched through the "TXT" file to get the corresponding number of the character, and then such numbers are combined into the encoding of text format in order.

The way I used this formula is that it would be slower for a "TXT" file with a lot of lines.

Thanks!

Accepted answers

txnelson

Try this formula, it may be faster

If( Row() == 1,
	d2 = Data Table( "test" );
	array = Associative Array( d2:txt << get values, d2:num << get values );
);
Parse( Char( array[Substr( :name, 1, 1 )] ) || Char( array[Substr( :name, 2, 1 )] ) || Char( array[Substr( :name, -1, 1 )] ) );

All comments

txnelson

Try this formula, it may be faster

If( Row() == 1,
	d2 = Data Table( "test" );
	array = Associative Array( d2:txt << get values, d2:num << get values );
);
Parse( Char( array[Substr( :name, 1, 1 )] ) || Char( array[Substr( :name, 2, 1 )] ) || Char( array[Substr( :name, -1, 1 )] ) );

lwx228

Thank Jim!

I tried it out, and this happened

txnelson

The characters in the column Name are all uppercase, and the characters in the column txt are all lowercase, so there is never a match

lwx228

Thank Jim!

If( Row() == 1,
	d2 = Data Table( "test" );
	array = Associative Array( d2:txt << get values, d2:num << get values );
);
Char( array[Substr( :name, 1, 1 )] ) || Char( array[Substr( :name, 2, 1 )] ) || Char( array[Substr( :name, -1, 1 )] ) ;