Find Uniqued Records

[LuckyMe]

It is very easy to find duplicated records by entering "!" in the Find Mode.

But let's say I have 100 records that contain same data such as "SA" in the field name called "Code". I want to Find such that it will return one record found for SA if I enter SA in Code in the Find mode.

Why do I do this? Well I just want to know there is a "SA" is existed or not WITHOUT showing me all records found that contain

[trevorg]

You could add to your find script:

If[status(CurrentFoundCount)>1]

ShowAllRecords

Omit Record

Show Omitted

End If

Then you would end up with only 1 of the SA codes.

[LuckyMe]

Thank you for a very quick answer. I have a similiar but "further" question. Actually this is my real question because last time I did not make myself clear.

Let's say I have six records that Code contains like this:

SA

SA12

SA3

SA12

SA13

SA13

then I want it return like this:

SA

SA1

SA3

SA12

SA13

Thank you very much again. It already took me almost a whole day to work on this problem.

[mborgens]

I think I understand your question. I made a text field "Serial", which allows me to find on "SA." I then made a calculation field, "Serialcalc" which gives a number result that is simply TextToNum(Serial). In this field I can sort "Serial" and have it sort correctly.

mb