[Vikalo]

This might be a dumb question but im struggling to figure it out im new to all of this, I have a few databases, I just need the email and pass but they have extra info in the txt file on each line like random hashes and numbers, is there an automated way to remove these like with an editor, i',m trying to figure it out but i can't, some help would be appreciated. 

---

[192]

I mean this sort of question is easily answered by AI. Or you can simply use the build in "replace" function in these text editors to get rid of useless info.

[retard]

Emeditor
regex, columns/csv by settings separator as what it is - right click csv, make sure allow delimiter in quotes option is disabled
sorting by length
sorting by length in columns
matching lines that are hashes with regex since they are same length

[Vikalo]

Emeditor
regex, columns/csv by settings separator as what it is - right click csv, make sure allow delimiter in quotes option is disabled
sorting by length
sorting by length in columns
matching lines that are hashes with regex since they are same length

Thanks gonna try this out.

[kap88]

u can use tools or ETL (Extract, Transform, Load) software to automate the process of cleaning and transforming your data: Fivetran, Talend, ...

[kap88]

Use a Script (Better for Big Files)
Python Example:
python
Copy
Edit
with open("input.txt", "r") as infile, open("output.txt", "w") as outfile:
for line in infile:
parts = line.strip().split(":")
if len(parts) >= 2:
email = parts[0]
password = parts[1]
outfile.write(f"{email}:{password}\n")
This reads the file line by line, grabs the email and password (first two parts), and writes them to a new file.