Return to forum
How to sort the database alphabetically?
by - Thursday, January 1, 1970 at 12:00 AM
Elite User
Elite
Posts: 127
Threads: 0
Joined: N/A
Reputation: 0

#1
October 16, 2022 at 1:06 AM
What program can sort a very large database (20+ GB) alphabetically? txt format
Reply
Uber User
Elite
Posts: 436
Threads: 0
Joined: N/A
Reputation: 1

#2
October 16, 2022 at 5:29 AM
convert the database to a .db file or something that works with sql, and you can use sql commands to sort it. Google what I said for the details.
Reply
BreachForums User
VIP
Posts: 8
Threads: 0
Joined: N/A
Reputation: 0

#3
October 16, 2022 at 9:40 AM
If the column you want to sort on is first:

cat files.txt | sort
Reply
Member
Member
Posts: 25
Threads: 0
Joined: N/A
Reputation: 0

#4
October 16, 2022 at 10:40 AM
what is the database format?

- if it is a basic text file, then it' DrD00m way, I think.
- if it is a sql relational database, then order by the column you target, and make sure the database has the proper collation.
Reply


 Users viewing this thread: How to sort the database alphabetically?: No users currently viewing.