Search similar entries

Closed
Posts
1
Registration date
Wednesday February 11, 2015
Status
Member
Last seen
February 11, 2015
-
Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
-
Hi,

I need to know, how to search similar entries in list of numeric entries.

eg:
Suppose I have numeric entries of 6 digits each having numbers among 1,2,3&4
Like: 123432, 213232, 321232, 413232...

In the list of numbers we will have many random numbers having 5 out 6 digits same and also in same sequence.
Like: 123123, 223123, 323123, 423123 (last 5 digits common in sequence)or
113123, 123123, 133123, 143123 (2nd digit uncommon rest common in sequence)
123121, 123122, 123123, 123124 (first 5 digits common in sequence)


Need to find such entries.
Please help

1 reply

Posts
2849
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 27, 2022
491
Hi Arpit.rastogi,

Try applying Filter (found under the Data tab), then click on the filter icon and use *23123, 1*3123 or 12312* for the three examples you provided.

Let us know if we can help you further.

Best regards,
Trowa