Index sorting

Question

In Swedish we have 3 letters at the end of the alphabet, å, ä and ö (in that order). If I make a table and ask FM to sort it for me, all letters come in the right order. But if I create an index FM treats ö as an o, and å and ä as a.

Is there a way to fix this? We use FM 7.2

Mike-Hardy · Accepted Answer

Mike-HardyI have now made a "dummy" index, just to explain what I mean (I changed the type so it's easier to see).----------------------This is the result I want, the index sorted right:Aalla 14Annat 14Cchans 14CW working 14Ffrånslagen 14Oorsak 14Pparentes 14ÅÅgren 14åker 14Äär 14Ärla 14Ööken 14Övrigt 14All letters sorted in the right order, and no difference between upper case and lower case----------------------------------Here is the standard reference pages:1, 2–3Symbols[\ ];Numerics[0];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<$symbols><$numerics><$alphabetics>--–—Level1IXopenObjectId <$relfilename>:<$ObjectType> <$ObjectId><$pagenum>---------------------------------The index ends up like this:AÅgren 14åker 14alla 14Annat 14är 14Ärla 14Cchans 14CW working 14Ffrånslagen 14Oöken 14orsak 14Övrigt 14Pparentes 14--------------------As you can see å and ä is under A and ö is under O.-------------------------If I add our special letters at the end the reference looks like this:1, 2–3Symbols[\ ];Numerics[0];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;Å;Ä;Ö<$symbols><$numerics><$alphabetics>--–—Level1IXopenObjectId <$relfilename>:<$ObjectType> <$ObjectId><$pagenum>-------------------------------The index ends up like this:ÅÅgren 14åker 14alla 14Annat 14är 14Ärla 14Cchans 14CW working 14Ffrånslagen 14Ööken 14orsak 14Övrigt 14Pparentes 14------------------For some reason a, å and ä is in the beginning under Å... ö is under O.----------------------------------To remove <$alphabetics> seems like a bad idea. It's back now.I have tried all other combinations; (Aa;Bb; and so on, nothing helps). I hope you understand what I mean and what I want.I understood what you meant, but didn't have any documentation available, and so was trying the wrong thing.I've just read Specify sort order for an index in the FM12 help, and it is now clear to me that the SortOrderIX paragraph is what needs changing. I have replaced the <$alphabetics> building block with its default value (as given in the above page of documentation), and then moved your Swedish letters to the end of the sort order. This is the result:for the GroupTitlesIX paragraph:Symbols[\ ];Numerics[0];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;Å;Ä;Öfor the SortOrderIX paragraph:<$symbols><$numerics>AÁÀÂÃaáàâãª Bb CÇcç Dd EÉÈÊËeéèêë Ffƒ Gg Hh IÍÌÎÏiìíîï Jj Kk Ll Mm NÑnñ OÓÒÔÕØoóòôõøº Pp Qq Rr Ss Tt UÚÙÛÜuúùûü Vv Ww Xx YŸyÿ Zz Åå Ää ÖöIt works for me in FM12.

lenahanson · Answer

I solved it. Or at least, I made it work. This is how my reference page looks like now:

---------------------

1, 2–3

Symbols[\ ];Numerics[0];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;å;ä;ö

<$symbols><$numerics>

--–—

Level1IX

openObjectId <$relfilename>:<$ObjectType> <$ObjectId>

<$pagenum>

-----------------

I added our special letters at the end, and removed <$alphabetics> as I read somewhere here here that FM got confused otherwise. Then I got the problem that the order was first all words that started with upper case, and then all words that started with lower case. So I changed all my indexed words to only contain lower case letters, and I also changed the line above to only contain lower case letters.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded