1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need help with mass txt editing

Discussion in 'BlackHat Lounge' started by Kraxas, Aug 28, 2013.

  1. Kraxas

    Kraxas Newbie

    Joined:
    Nov 3, 2012
    Messages:
    37
    Likes Received:
    1
    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!
     
    Last edited: Aug 28, 2013
  2. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,114
    Likes Received:
    2,892
    Gender:
    Male
    Use Excel, import them as csv, as choose : as separator. It should be easy.
     
    • Thanks Thanks x 1
  3. Bruut

    Bruut Regular Member

    Joined:
    Aug 9, 2012
    Messages:
    232
    Likes Received:
    150
    Excel is the only way i can think of. Just download a portable version with torrent :)
     
  4. pavan

    pavan Elite Member

    Joined:
    Mar 30, 2008
    Messages:
    1,603
    Likes Received:
    432
    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
     
  5. bartosimpsonio

    bartosimpsonio Jr. VIP Jr. VIP Premium Member

    Joined:
    Mar 21, 2013
    Messages:
    10,013
    Likes Received:
    8,697
    Occupation:
    Buy AdSense IDs List
    Location:
    Buy AdSense IDs List
    Home Page:
    In Perl:

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

    DarkPixel Jr. VIP Jr. VIP

    Joined:
    Oct 4, 2011
    Messages:
    1,341
    Likes Received:
    1,245
    Location:
    ↓↓↓↓
    Home Page:
  7. Kraxas

    Kraxas Newbie

    Joined:
    Nov 3, 2012
    Messages:
    37
    Likes Received:
    1
    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!
     
    Last edited: Aug 28, 2013
  8. sockpuppet

    sockpuppet Junior Member

    Joined:
    Nov 7, 2011
    Messages:
    155
    Likes Received:
    145
    cut -d : -f 1,3
    or
    cut -d : -f 2,3