Author Topic: How do you find all the draws with numbers?  (Read 5950 times)

0 Members and 1 Guest are viewing this topic.

Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
How do you find all the draws with numbers?
« on: July 04, 2020, 01:29:52 am »
How to find and extract one number with twenty numbers in sets in a text file? Or how to find a duplicate number on each separate line.
20 + 1

03,10,15,16,26,29,32,33,43,51,56,59,63,65,66,69,71,72,74,75,15 YES
02,03,16,17,18,21,27,43,46,49,51,55,58,59,61,70,71,73,76,78,28 NO

These are "lotto numbers"

i use EmEditor or Notepad++

« Last Edit: July 04, 2020, 01:36:42 am by Angelika »

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #1 on: July 04, 2020, 02:14:24 am »
How is this Computer Help ?

Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #2 on: July 04, 2020, 03:29:21 am »
My computer needs no repair help. Help get associated with any text editor, I asked in various forums, but no one can help in this case for a long time. For me is complex issue, so none any idea in my head.  :undecided:

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #3 on: July 04, 2020, 03:46:23 am »
If this is for a Lotto game then sometimes it's advantageous to have duplicated numbers on different lines as I have found.

Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #4 on: July 04, 2020, 07:32:33 am »
This means that it is not possible to find all duplicates in separate lines in a text editor and extract all these lines???
And I have always believed that everything is possible, only more time is needed.

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #5 on: July 04, 2020, 02:32:40 pm »
Before the UK's national lottery was increased from £1.00 a line to £2.00 a line, I used to select 10 random numbers and split them into two groups of five.

I then used the first group of 5 and one each of the other group and then used the second group with one each of the first group to give me 10 lines of six numbers.

I was fortunate on one of the draws to have 4 numbers correct which paid me about £400.00.

Those duplicated numbers produced 5 lines of 4 correct.

This is why I don't think you should bother trying to find a method of weeding out those duplicated numbers.


Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #6 on: July 06, 2020, 04:16:08 am »
ok, let's not talk about the lottery anymore, forget about it.
I don't want to remove duplicates, I just want to find similar numbers that repeat, I understand that even the best forum experts can't answer. They have no idea how to find it. I didn't know that 20 numbers is the biggest, most complicated thing in the world.
Of course this is possible, but how do you use cells?
Compare cells, the search operation should take one second (yes, extremely fast in EmEditor), but where is the compare cells option.
1 second and you have the result, I just don't know how to use "cell" Emeditor

see: https://www.youtube.com/watch?v=ZQahhj9tBkM
« Last Edit: July 06, 2020, 04:21:41 am by Angelika »

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #7 on: July 06, 2020, 10:09:03 am »
From the video I couldn't see how you could do what you want.

You can compare cells using a spreadsheet but it compares one column against another, which is probably not what you want, but perhaps you could work your numbers into columns.

This is how to do it in a Google Sheet - https://www.techrepublic.com/article/how-to-find-duplicates-in-google-sheets/

This is the download for a Google Sheet to see if it helps - https://www.google.co.uk/sheets/about/


Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #8 on: July 08, 2020, 03:59:35 am »
I don't understand the sheets - I have no idea what these commands are about ...
I am not a programmer-mathematician, nor do I know what these formulas mean ...
Even if this is explained by some short examples, I still don't know what's going on ...
I tried to do it, but there is always no expected result, even in 1%.
« Last Edit: July 08, 2020, 04:03:16 am by Angelika »

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #9 on: July 08, 2020, 10:07:25 am »
It's over 25yrs since I did any work on spreadsheets and what I learned then is mostly forgotten.

Because of my age, my brain isn't as agile as it once was so I am unable to help you with those either.

Perhaps you may know someone who can.

Offline Angelika

  • Sr. Member
  • ****
  • Join Date: Feb 2017
  • Posts: 307
  • Karma: -2
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #10 on: July 08, 2020, 10:53:12 am »
There are solutions like everywhere "Two column"
"How to compare two columns in Excel for matches and differences"
But I don't have two columns, only 21 columns(cell) and here is the problem.

Offline Boggin

  • Global Moderator
  • Hero Member
  • *****
  • Join Date: Jul 2014
  • Posts: 10182
  • Location: UK
  • Karma: 122
    • View Profile
Re: How do you find all the draws with numbers?
« Reply #11 on: July 08, 2020, 02:21:00 pm »
This is how do check a single column using Excel which is a paid for program https://www.techrepublic.com/blog/windows-and-office/how-to-find-duplicates-in-excel-245163/

However, LibreOffice is a free office suite which has a spreadsheet so the steps may be similar if it has that option.

https://www.libreoffice.org/download/download/