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

how to change mail:pass to username:pass

Discussion in 'BlackHat Lounge' started by Deetssosa, Mar 16, 2015.

  1. Deetssosa

    Deetssosa Newbie

    Joined:
    Mar 16, 2015
    Messages:
    15
    Likes Received:
    1
    Apologies if this question has been answered already I've been searching everywhere but cant find a solution I basically want to

    change for example e - mail | password

    to this > deanimperato1|london44

    so basically cutting out the domain and leaving the id
    I have 5m list I want change at least 100k however I refuse to do it one by one I'm sure there is a way as checkers like ione do this for you automatically.


    P.S I'm a bit of a noob so please spare me the advanced terminology
     
  2. hpasha

    hpasha Jr. VIP Jr. VIP

    Joined:
    May 15, 2011
    Messages:
    1,360
    Likes Received:
    185
    Location:
    Kepler 186F
    Use edit plus or similar text editor.

    Use Find & Replace option and remove the domain.com from the list.

    Thats it
     
  3. qrazy

    qrazy Senior Member

    Joined:
    Mar 19, 2012
    Messages:
    1,115
    Likes Received:
    1,725
    Location:
    Banana Republic
    Open the file with Excel and it will prompt you to specify the delimiter, just enter "|" as the delimiter character and finally swap the columns and save it back.
     
  4. Apricot

    Apricot Administrator Staff Member Moderator

    Joined:
    Mar 26, 2013
    Messages:
    12,784
    Likes Received:
    8,186
    Gender:
    Female
    Occupation:
    BHW Admin
    Location:
    Station 2E
    Home Page:
    I use Notepad++ for things like this. Use the find and replace tool. (CTRL + F)
     
  5. Deetssosa

    Deetssosa Newbie

    Joined:
    Mar 16, 2015
    Messages:
    15
    Likes Received:
    1
    Alright I'll go ahead and use Notepad++ as I already tried excel