Need help with mass txt editing

Hi i'm not really sure that i can post here but i haven't found a better place so... sorry if i opened it in the wrong zone, anyway i have a BIG X:Y:Z list but i need something like Y:Z or X:Z and so on, i don't have any idea on how mass edit it (basicly delete all the X or Y or Z colomn). The list is in .txt the only thing that come in my mind is excel meaby i can import it and than delete a colomn but any easier and faster way is accepted becouse right now i haven't it installed on my pc. thanks guys!

EDIT i used open office no problem importing the file but having some trouble exporting it... i'll play with the options but if someone know how to do it let me know thanks!

Use Excel, import them as csv, as choose : as separator. It should be easy.

Excel is the only way i can think of. Just download a portable version with torrent

easiest way would be by using excel
if you dont have that then you can use openoffice
if you dont wanna install that even then use google docs
its online as well as free

In Perl:

open(FIL,"yourfile.txt")
while(<FIL>) { my ($a,$b,$c) = split /\:/; print "A = $a B = $b C = $c" }

OpenOffice or Excel

okok thanks guys for the help i'll try excel

EDIT i used open office no problem importing the file but having some trouble exporting it... i'll play with the options but if someone know how to do it let me know thanks!

cut -d : -f 1,3
or
cut -d : -f 2,3