Jump to content
Sign in to follow this  
LuckyMe

Find Uniqued Records

This topic is 6519 days old. Please don't post here. Open a new topic instead.

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

This topic is 6519 days old. Please don't post here. Open a new topic instead.

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.