Tweaking.com Support Forums
Main Forum => General Computer Support => Topic started by: Angelika 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++
-
How is this Computer Help ?
-
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:
-
If this is for a Lotto game then sometimes it's advantageous to have duplicated numbers on different lines as I have found.
-
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.
-
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.
-
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
-
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/
-
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%.
-
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.
-
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.
-
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/