iTeddyZ
Member
- Joined
- Feb 10, 2010
- Sythe Gold
- 0
- Messages
- 85
hi,
how would i delete a bunch of things after a certain phrase? like this
E0 ddb0b8bbf60b728fce9ace252db2a1eef68119c7
E1 07460df10583e94e946fbaccc6e1e861aabd5e23
E2 16d509a7146781ec37fe7fba349b58e79ee2f65b
E3 04cf543b0b92601f0116cc36df4b8942b670408a
E4 848092869692ce97dbb3c640936266de3a678fe2
E5 9a86054ee3627014bb2f372f939ff22772a90aa5
E6 2b699093a4e81395e4b6239d9a24e1ac3f6e3726
E7 ebc3b18e39c91b866cdd7c266014f266e27d9245
E8 2b0ee5ac2e3ca5ab194a88e9e280819804a71de8
E9 bd9485408996478efd229b846194172187992fcc
i have about 3000 lines of those but i just want to delete thing thing after the 2 characters. so the above should look like this
E0
E1
E2
E3
E4
E5 and so on
any suggestions? and it could be saved as a text file or a word file, it doesnt matter i just want the list with only the 2 characters in each row
thanks
EDIT:
i figured it out! it took me about 20 minutes of research but what i did was paste the data into excel, used text to columns under data and messed around from there!
how would i delete a bunch of things after a certain phrase? like this
E0 ddb0b8bbf60b728fce9ace252db2a1eef68119c7
E1 07460df10583e94e946fbaccc6e1e861aabd5e23
E2 16d509a7146781ec37fe7fba349b58e79ee2f65b
E3 04cf543b0b92601f0116cc36df4b8942b670408a
E4 848092869692ce97dbb3c640936266de3a678fe2
E5 9a86054ee3627014bb2f372f939ff22772a90aa5
E6 2b699093a4e81395e4b6239d9a24e1ac3f6e3726
E7 ebc3b18e39c91b866cdd7c266014f266e27d9245
E8 2b0ee5ac2e3ca5ab194a88e9e280819804a71de8
E9 bd9485408996478efd229b846194172187992fcc
i have about 3000 lines of those but i just want to delete thing thing after the 2 characters. so the above should look like this
E0
E1
E2
E3
E4
E5 and so on
any suggestions? and it could be saved as a text file or a word file, it doesnt matter i just want the list with only the 2 characters in each row
thanks
EDIT:
i figured it out! it took me about 20 minutes of research but what i did was paste the data into excel, used text to columns under data and messed around from there!










