I
I
Ivan_Google2020-07-20 17:34:13
cmd/bat
Ivan_Google, 2020-07-20 17:34:13

How to clear a huge txt from duplicates?

you need to clear the .txt file weighing 25GB from the same lines
example:

123
456qwerty
123
jsdgf6

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Roman Mirilaczvili, 2020-07-20
@Ivan_Google

A modified version of Stalker_RED in which, instead of DISTINCT, build a schema with a varchar primary key, in which to enter data from the 1st table using a query
Insert ignore into ... select from ...

D
Dimonchik, 2020-07-20
@dimonchik2013

download TextPad
https://www.textpad.com/home
then F9
and tick "delete duplicates"
when it opens the file - it freezes, it doesn't have a process line, unlike EmEditor, wait until it opens
if it doesn't open - the computer doesn't pull - then other methods
like this

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question