Jump to content
Sign in to follow this  
LuckyMe

Find Uniqued Records

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.