Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Mike Foran]

I have added a library field to sort my music by LP side. Internally, I use an integer, because that's easier to compute. But for display, I want to convert that number to a letter, so it displays "Side A" instead of "Side 1." I'm currently using this mouthful of an expression to calculate the conversion:

Code: [Select]

ifelse(isequal([LP Side], 1), A, isequal([LP Side], 2), B, isequal([LP Side], 3), C, isequal([LP Side], 4), D, isequal([LP Side], 5), E, isequal([LP Side], 6), F, isequal([LP Side], 7), G, isequal([LP Side], 8), H, isequal([LP Side], 9), I, isequal([LP Side], 10), J, isequal([LP Side], 11), K, isequal([LP Side], 12), L, isequal([LP Side], 13), M, isequal([LP Side], 14), N,isequal([LP Side], 15), O, isequal([LP Side], 16), P)
It works, but a cumbersome solution. It would work much better if the expression were something that can more dynamically convert, but I don't know how to convert a number to a corresponding letter of the alphabet. None of my LPs or sets have more than 26 sides so I don't need any trap to convert beyond side 26. Can any expression gurus here suggest an way?

[Mike Foran]

Just to follow up, this expression is a lot neater:

ListItem(;A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z, [LP Side])

[ferday]

Good one - I've been away from computer so didn't post back but you found it yourself

[Mike Foran]

I had some help.