Windows XP
FMPro: 6.0.x

This is a little related to my duplicate issue posted earlier today.
When sorting my files, I have software named modules that are both ada
and ada spec, and their filenames are listed as "filename.ada" or
"filename_.ada"

When I'm sorting files, it looks like filemaker pro doesn't know what
to do with a filename that has a "_." appended in it. When I look at
my portal (which is sorted by name), it does list things
alphabetically, however, if there are duplicates, it comes off as the
following when an "_." is there...

Example:

AAAA.ada
AAAA_.ada
AAAA.ada
AAAA_.ada
BBBB.txt
CCCC_111_DDD.doc
CCCC_111_EEE.doc

etc... etc...

How can I get my sort to look like the following:

AAAA.ada
AAAA.ada
AAAA_.ada
AAAA_.ada
BBBB.txt
CCCC_111_DDD.doc
CCCC_111_EEE.doc

Once this problem is solved, I think what I'm doing to remove
duplicates via the export technique will work. Thank you again for any
help on this matter!

- Teresa

For sorting properly, you may create a new field "ZZ" =
Substitute(YourField, "_", "Z"), and sort by ZZ and no longer by
YourField. But of course you'll show YourField and not the ZZ.
Remi-Noel


"Teresa K." <teresa.kabourek (AT) ngc (DOT) com> a écrit ...

Or just set the sorting language to ASCII instead of english. English
ignores underscores, ASCII does not.

(one caveat with ASCII -- ASCII differentiates between "a" and "A". If
that's a problem I'd go with Remi-Noel's solution although i'd go about
it differently... i'd define the new field as Upper(yourfield), and do
the sort by ascii.

This is more generally robust than than only handling the underscore.

-regards,
Dave

In article <4359542f$0$2659$626a14ce (AT) news (DOT) free.fr>, rnmenegaux (AT) free (DOT) fr
says...