How to extract these names?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dirty F
    Too lazy to set a custom title
    • Jul 2001
    • 59204

    #1

    How to extract these names?

    If i have a text file that looks like this:

    MARY 2.629 6,538,323 1
    PATRICIA 1.073 2,668,551 2
    LINDA 1.035 2,574,045 3
    BARBARA 0.98 2,437,260 4
    ELIZABETH 0.937 2,330,319 5
    JENNIFER 0.932 2,317,884 6
    MARIA 0.828 2,059,236 7
    SUSAN 0.794 1,974,678 8
    MARGARET 0.768 1,910,016 9
    DOROTHY 0.727 1,808,049 10
    LISA 0.704 1,750,848 11
    NANCY 0.669 1,663,803 12
    KAREN 0.667 1,658,829 13
    BETTY 0.666 1,656,342 14
    HELEN 0.663 1,648,881 15
    SANDRA 0.629 1,564,323 16
    DONNA 0.583 1,449,921 17
    CAROL 0.565 1,405,155 18
    RUTH 0.562 1,397,694 19
    SHARON 0.522 1,298,214 20
    MICHELLE 0.519 1,290,753 21
    LAURA 0.51 1,268,370 22
    SARAH 0.508 1,263,396 23
    KIMBERLY 0.504 1,253,448 24
    DEBORAH 0.494 1,228,578 25
    JESSICA 0.49 1,218,630 26
    SHIRLEY 0.482 1,198,734 27
    CYNTHIA 0.469 1,166,403 28
    ANGELA 0.468 1,163,916 29
    MELISSA 0.462 1,148,994 30
    BRENDA 0.455 1,131,585 31
    AMY 0.451 1,121,637 32
    ANNA 0.44 1,094,280 33
    REBECCA 0.43 1,069,410 34
    VIRGINIA 0.43 1,069,410 35
    KATHLEEN 0.424 1,054,488 36
    PAMELA 0.416 1,034,592 37
    MARTHA 0.412 1,024,644 38
    DEBRA 0.408 1,014,696 39
    AMANDA 0.404 1,004,748 40
    STEPHANIE 0.4 994,800 41
    CAROLYN 0.385 957,495 42
    CHRISTINE 0.382 950,034 43
    MARIE 0.379 942,573 44
    JANET 0.379 942,573 45
    CATHERINE 0.373 927,651 46
    FRANCES 0.37 920,190 47
    ANN 0.364 905,268 48

    But then bigger, is there a way to extract the names from it?
  • Fake Nick
    So Fucking Banned
    • Jul 2004
    • 7708

    #2
    no thats impossible

    Comment

    • WiredGuy
      Pounding Googlebot
      • Aug 2002
      • 34512

      #3
      A simple script can extract all this data. If you're not a programmer, then you could make a copy of all this data, and then do a search and replace in Microsoft Word to remove all the numbers and excess spaces.

      In Word: Ctrl-H to load S&R
      ^#.^#^#^# ^#,^#^#^#,^#^#^# ^#

      This will replace all space-#.###-space-#,###,###-space-# from the string. That's assuming all your data is exactly this many characters. Obviously a perl/php or similiar scripting language script is best to go unless you don't have experience with them.

      WG
      Last edited by WiredGuy; 12-20-2004, 01:30 PM.
      I play with Google.

      Comment

      • Naughty
        Confirmed User
        • Jul 2001
        • 6478

        #4
        Originally posted by Fake Nick
        no thats impossible
        No it is not. Somebody with basic php skills can strip everything after the first space
        seks.ai for sale - ping me

        Comment

        • xxxdesign-net
          My hips don't lie
          • Nov 2002
          • 10129

          #5
          checkout EXTRACTNAMES 2.3 by Softyfg

          Comment

          • polish_aristocrat
            Too lazy to set a custom title
            • Jul 2002
            • 40377

            #6
            I would do it manually, lol, but probably there's a way.
            I don't use ICQ anymore.

            Comment

            • Fake Nick
              So Fucking Banned
              • Jul 2004
              • 7708

              #7
              Originally posted by Naughty
              No it is not. Somebody with basic php skills can strip everything after the first space

              sorry its impossible

              Comment

              • Dirty F
                Too lazy to set a custom title
                • Jul 2001
                • 59204

                #8
                Originally posted by polish_aristocrat
                I would do it manually, lol, but probably there's a way.
                Where can i send the text file?

                Comment

                • Wizzo
                  2011 GFY Hall of Fame!
                  • Nov 2000
                  • 15224

                  #9
                  Hey Battuss you got ICQ....
                  Looking for Opportunity!

                  Comment

                  • polish_aristocrat
                    Too lazy to set a custom title
                    • Jul 2002
                    • 40377

                    #10
                    Originally posted by Battuss
                    Where can i send the text file?
                    lol, how much are you paying?
                    I don't use ICQ anymore.

                    Comment

                    • Dirty F
                      Too lazy to set a custom title
                      • Jul 2001
                      • 59204

                      #11
                      Originally posted by Wizzo
                      Hey Battuss you got ICQ....
                      Nothing showing up man :/

                      Whats yer # ?

                      Comment

                      • Wizzo
                        2011 GFY Hall of Fame!
                        • Nov 2000
                        • 15224

                        #12
                        117009101
                        Looking for Opportunity!

                        Comment

                        • modF
                          Confirmed User
                          • Aug 2002
                          • 1888

                          #13
                          Open it in excel, text to colums by a delimited space and then just delete the other colums. Done and done.

                          I do things
                          skype:themodF

                          Comment

                          • European Lee
                            Confirmed User
                            • Dec 2002
                            • 7133

                            #14
                            Open the file in notepad.

                            Search and replace every number with nothing.

                            Regards,

                            Lee
                            YOUR TRAFFIC IS SAFE WITH US - CONDOM CASH
                            PUTTING THE GAY ADULT INDUSTRY ON YOUR PC!!
                            AFFORDABLE 2257 COMPLIANT GAY + BI CONTENT

                            Comment

                            • polish_aristocrat
                              Too lazy to set a custom title
                              • Jul 2002
                              • 40377

                              #15
                              Originally posted by European Lee
                              Open the file in notepad.

                              Search and replace every number with nothing.

                              Regards,

                              Lee
                              I just wanted to try it but it doesn't work for me for some reason.

                              edited - i did what you said, I open the replace feature, but how do i replace all numbers?
                              I don't use ICQ anymore.

                              Comment

                              • r3ap3r
                                Confirmed User
                                • Jul 2004
                                • 3535

                                #16
                                I could do it for you. But it will cost you. Depending on how many name you have I can have it ready in 1 hour
                                Fuck My Sig Good
                                ICQ - 203744959

                                Comment

                                • tranza
                                  ICQ: 197-556-237
                                  • Jun 2003
                                  • 57559

                                  #17
                                  Originally posted by Battuss
                                  Where can i send the text file?
                                  I'm just a newbie.

                                  Comment

                                  • ztik
                                    Confirmed User
                                    • Aug 2001
                                    • 5196

                                    #18
                                    Import it into microsoft excel from text and make each colum seperated by a Space Copy the colums you want to another file
                                    .

                                    Comment

                                    • pornguy
                                      Too lazy to set a custom title
                                      • Mar 2003
                                      • 62910

                                      #19
                                      Excell will do it with no problem.
                                      PornGuy skype me pornguy_epic

                                      AmateurDough The Hottes Shemales online!
                                      TChicks.com | Angeles Cid | Mariana Cordoba | MAILERS WELCOME!

                                      Comment

                                      • Repetitive Monkey
                                        Confirmed User
                                        • Feb 2004
                                        • 3505

                                        #20
                                        Monkey to the rescue!

                                        PHP Code:
                                        <?
                                        $file=@file("bla.txt");
                                        if($file){
                                            for($i=0;$i=count($file);$i++){
                                            $split=explode(" ",$file[$i]);
                                                if($split[0]){
                                                echo $split[0]."<br>\n";
                                                }
                                            }
                                        }
                                        ?>
                                        Replace the haha stuff with you know what.

                                        Comment

                                        • pornguy
                                          Too lazy to set a custom title
                                          • Mar 2003
                                          • 62910

                                          #21
                                          MARY
                                          PATRICIA
                                          LINDA
                                          BARBARA
                                          ELIZABETH
                                          JENNIFER
                                          MARIA
                                          SUSAN
                                          MARGARET
                                          DOROTHY
                                          LISA
                                          NANCY
                                          KAREN
                                          BETTY
                                          HELEN
                                          SANDRA
                                          DONNA
                                          CAROL
                                          RUTH
                                          SHARON
                                          MICHELLE
                                          LAURA
                                          SARAH
                                          KIMBERLY
                                          DEBORAH
                                          JESSICA
                                          SHIRLEY
                                          CYNTHIA
                                          ANGELA
                                          MELISSA
                                          BRENDA
                                          AMY
                                          ANNA
                                          REBECCA
                                          VIRGINIA
                                          KATHLEEN
                                          PAMELA
                                          MARTHA
                                          DEBRA
                                          AMANDA
                                          STEPHANIE
                                          CAROLYN
                                          CHRISTINE
                                          MARIE
                                          JANET
                                          CATHERINE
                                          FRANCES
                                          ANN




                                          Told ya!
                                          PornGuy skype me pornguy_epic

                                          AmateurDough The Hottes Shemales online!
                                          TChicks.com | Angeles Cid | Mariana Cordoba | MAILERS WELCOME!

                                          Comment

                                          • Fake Nick
                                            So Fucking Banned
                                            • Jul 2004
                                            • 7708

                                            #22
                                            MARY
                                            PATRICIA
                                            LINDA
                                            BARBARA
                                            ELIZABETH
                                            JENNIFER
                                            MARIA
                                            SUSAN
                                            MARGARET
                                            DOROTHY
                                            LISA
                                            NANCY
                                            KAREN
                                            BETTY
                                            HELEN
                                            SANDRA
                                            DONNA
                                            CAROL
                                            RUTH
                                            SHARON
                                            MICHELLE
                                            LAURA
                                            SARAH
                                            KIMBERLY
                                            DEBORAH
                                            JESSICA
                                            SHIRLEY
                                            CYNTHIA
                                            ANGELA
                                            MELISSA
                                            BRENDA
                                            AMY
                                            ANNA
                                            REBECCA
                                            VIRGINIA
                                            KATHLEEN
                                            PAMELA
                                            MARTHA
                                            DEBRA
                                            AMANDA
                                            STEPHANIE
                                            CAROLYN
                                            CHRISTINE
                                            MARIE
                                            JANET
                                            CATHERINE
                                            FRANCES
                                            ANN

                                            how many do you have?

                                            Comment

                                            • Fake Nick
                                              So Fucking Banned
                                              • Jul 2004
                                              • 7708

                                              #23
                                              Originally posted by pornguy
                                              MARY
                                              PATRICIA
                                              LINDA




                                              Told ya!

                                              beat me to it

                                              Comment

                                              • Trixxxia
                                                Confirmed User
                                                • Aug 2004
                                                • 5600

                                                #24
                                                Well I know the old fashioned/non-programmer way. Put it in a text file - in a blank area make a 'tab' --> copy that space-> go to replace ->put a space on the find-> paste the tab that you copied earlier->and put a space with the spacebar. It should put a tab after the name. Then copy & paste in Excel - everything will be in it's own column - take the column with the names and paste in Notepad if you need it in text.

                                                Comment

                                                • European Lee
                                                  Confirmed User
                                                  • Dec 2002
                                                  • 7133

                                                  #25
                                                  Originally posted by polish_aristocrat
                                                  I just wanted to try it but it doesn't work for me for some reason.

                                                  edited - i did what you said, I open the replace feature, but how do i replace all numbers?
                                                  One at a time like this..



                                                  Put a number in the top field, leave the second field blank then hit 'Replace All'

                                                  Regards,

                                                  Lee
                                                  YOUR TRAFFIC IS SAFE WITH US - CONDOM CASH
                                                  PUTTING THE GAY ADULT INDUSTRY ON YOUR PC!!
                                                  AFFORDABLE 2257 COMPLIANT GAY + BI CONTENT

                                                  Comment

                                                  • pornguy
                                                    Too lazy to set a custom title
                                                    • Mar 2003
                                                    • 62910

                                                    #26
                                                    Just open the txt file in excel, and it will run you trhough the wizzard.
                                                    PornGuy skype me pornguy_epic

                                                    AmateurDough The Hottes Shemales online!
                                                    TChicks.com | Angeles Cid | Mariana Cordoba | MAILERS WELCOME!

                                                    Comment

                                                    • rowan
                                                      Too lazy to set a custom title
                                                      • Mar 2002
                                                      • 17393

                                                      #27
                                                      Got shell access?

                                                      cat file.txt | awk '{print $1}' > newfile.txt


                                                      edit: haha123 = open brace (above the [ key)
                                                      Last edited by rowan; 12-20-2004, 02:02 PM.

                                                      Comment

                                                      • polish_aristocrat
                                                        Too lazy to set a custom title
                                                        • Jul 2002
                                                        • 40377

                                                        #28
                                                        Originally posted by European Lee
                                                        One at a time like this..



                                                        Put a number in the top field, leave the second field blank then hit 'Replace All'

                                                        Regards,

                                                        Lee
                                                        Awesome, thanks.
                                                        I don't use ICQ anymore.

                                                        Comment

                                                        • Dirty F
                                                          Too lazy to set a custom title
                                                          • Jul 2001
                                                          • 59204

                                                          #29
                                                          Hmm excel i no have.

                                                          http://names.mongabay.com/female_names.htm

                                                          Could someone be so nice to do the female 1-1000 list and the last name list
                                                          http://names.mongabay.com/most_common_surnames.htm

                                                          That would be awesome.

                                                          Comment

                                                          • rowan
                                                            Too lazy to set a custom title
                                                            • Mar 2002
                                                            • 17393

                                                            #30
                                                            Originally posted by Battuss
                                                            Hmm excel i no have.

                                                            http://names.mongabay.com/female_names.htm

                                                            Could someone be so nice to do the female 1-1000 list and the last name list
                                                            http://names.mongabay.com/most_common_surnames.htm

                                                            That would be awesome.
                                                            Hmmm, first and last names... making up a list of fake "from" names to feed your spamming program?

                                                            Comment

                                                            • Dirty F
                                                              Too lazy to set a custom title
                                                              • Jul 2001
                                                              • 59204

                                                              #31
                                                              Originally posted by rowan
                                                              Hmmm, first and last names... making up a list of fake "from" names to feed your spamming program?
                                                              No, i only use the name Rowan from gfy for that.

                                                              Comment

                                                              • Fake Nick
                                                                So Fucking Banned
                                                                • Jul 2004
                                                                • 7708

                                                                #32
                                                                http://www.latinapussy.info/names1.txt

                                                                http://www.latinapussy.info/names2.txt

                                                                that'll be $100 pls

                                                                Comment

                                                                • Dirty F
                                                                  Too lazy to set a custom title
                                                                  • Jul 2001
                                                                  • 59204

                                                                  #33
                                                                  Originally posted by Fake Nick
                                                                  http://www.latinapussy.info/names1.txt

                                                                  http://www.latinapussy.info/names2.txt

                                                                  that'll be $100 pls
                                                                  Dude, i dont want it from you.

                                                                  You should know that.

                                                                  Comment

                                                                  • Fake Nick
                                                                    So Fucking Banned
                                                                    • Jul 2004
                                                                    • 7708

                                                                    #34
                                                                    Originally posted by Battuss
                                                                    Dude, i dont want it from you.

                                                                    You should know that.

                                                                    ok will delete both files then ,


                                                                    I will also hire someone to scann your hard drive, if one of those two files are on it you will hear from my lawyer

                                                                    Comment

                                                                    • rowan
                                                                      Too lazy to set a custom title
                                                                      • Mar 2002
                                                                      • 17393

                                                                      #35
                                                                      Originally posted by Fake Nick
                                                                      http://www.latinapussy.info/names1.txt

                                                                      http://www.latinapussy.info/names2.txt

                                                                      that'll be $100 pls
                                                                      Too easy, you should do something asshole-ish like cut the first letter from every name.

                                                                      Comment

                                                                      • Dirty F
                                                                        Too lazy to set a custom title
                                                                        • Jul 2001
                                                                        • 59204

                                                                        #36
                                                                        Originally posted by Fake Nick
                                                                        ok will delete both files then ,


                                                                        I will also hire someone to scann your hard drive, if one of those two files are on it you will hear from my lawyer
                                                                        Ahahah yes, youve got a good case if you scan my harddrive haha.

                                                                        And dont worry, i didnt even click the files.

                                                                        Comment

                                                                        • Moreno
                                                                          Registered User
                                                                          • Dec 2004
                                                                          • 95

                                                                          #37
                                                                          Hello, let me introduce myself: I'm a perl and php programmer with 10 yrs of experience, and I can do *EVERYTHING*..

                                                                          Just drop me PM

                                                                          Comment

                                                                          • Funky Bastard
                                                                            So Fucking Banned
                                                                            • Nov 2004
                                                                            • 2544

                                                                            #38
                                                                            Humm I can do that with emails and domains but nope not what you want!

                                                                            Comment

                                                                            • BackToMine
                                                                              Confirmed User
                                                                              • Nov 2004
                                                                              • 541

                                                                              #39
                                                                              Originally posted by modF
                                                                              Open it in excel, text to colums by a delimited space and then just delete the other colums. Done and done.
                                                                              LOL that's what I do too.
                                                                              Only reason I have Excel installed!

                                                                              Comment

                                                                              • Fred Quimby
                                                                                Confirmed User
                                                                                • Jul 2004
                                                                                • 5430

                                                                                #40
                                                                                i use excel for stuff like that

                                                                                Comment

                                                                                • pornJester
                                                                                  Confirmed User
                                                                                  • Mar 2001
                                                                                  • 6138

                                                                                  #41
                                                                                  That's easy. Do a search and replace on the numbers (0-9) and replace with nothing. Then do the same on the other characters and spaces. Should take all of 1 minute.


                                                                                  FreshBucks | Webmaster Vault | GayAW
                                                                                  Trusted Names in Adult.
                                                                                  ICQ 9157.3698

                                                                                  Comment

                                                                                  • Dirty F
                                                                                    Too lazy to set a custom title
                                                                                    • Jul 2001
                                                                                    • 59204

                                                                                    #42
                                                                                    Originally posted by pornJester
                                                                                    That's easy. Do a search and replace on the numbers (0-9) and replace with nothing. Then do the same on the other characters and spaces. Should take all of 1 minute.
                                                                                    Well, im gonna try that then.

                                                                                    Comment

                                                                                    • Repetitive Monkey
                                                                                      Confirmed User
                                                                                      • Feb 2004
                                                                                      • 3505

                                                                                      #43
                                                                                      I already posted the code, it isn't good enough?

                                                                                      Comment

                                                                                      • Fake Nick
                                                                                        So Fucking Banned
                                                                                        • Jul 2004
                                                                                        • 7708

                                                                                        #44
                                                                                        Originally posted by pornJester
                                                                                        That's easy. Do a search and replace on the numbers (0-9) and replace with nothing. Then do the same on the other characters and spaces. Should take all of 1 minute.

                                                                                        I did that for him and made two easy txt files


                                                                                        http://www.latinapussy.info/names_1.txt

                                                                                        http://www.latinapussy.info/names_2.txt


                                                                                        but they werent good enough and he now accuses me of stalking

                                                                                        Comment

                                                                                        • Dirty F
                                                                                          Too lazy to set a custom title
                                                                                          • Jul 2001
                                                                                          • 59204

                                                                                          #45
                                                                                          Ok, that worked, thanks peeps.

                                                                                          Comment

                                                                                          • Dirty F
                                                                                            Too lazy to set a custom title
                                                                                            • Jul 2001
                                                                                            • 59204

                                                                                            #46
                                                                                            Originally posted by Repetitive Monkey
                                                                                            I already posted the code, it isn't good enough?
                                                                                            :/

                                                                                            Comment

                                                                                            • Repetitive Monkey
                                                                                              Confirmed User
                                                                                              • Feb 2004
                                                                                              • 3505

                                                                                              #47
                                                                                              Originally posted by Battuss
                                                                                              :/
                                                                                              What? Why?

                                                                                              Comment

                                                                                              • Dirty F
                                                                                                Too lazy to set a custom title
                                                                                                • Jul 2001
                                                                                                • 59204

                                                                                                #48
                                                                                                Originally posted by Repetitive Monkey
                                                                                                What? Why?
                                                                                                Nothing man haha.

                                                                                                Comment

                                                                                                • bryc
                                                                                                  Confirmed User
                                                                                                  • Apr 2001
                                                                                                  • 102

                                                                                                  #49
                                                                                                  you got that all sorted out now Battus? If not I know a free tool that may help ya...

                                                                                                  Hit me on icq 209182384

                                                                                                  Comment

                                                                                                  • Babaganoosh
                                                                                                    ♥♥♥ Likes Hugs ♥♥♥
                                                                                                    • Nov 2001
                                                                                                    • 15841

                                                                                                    #50
                                                                                                    Originally posted by Battuss
                                                                                                    Nothing man haha.
                                                                                                    If you didn't get it done yet just email the list to me at support AT adultdevil.com or ICQ 4445137 and I will hook you up. Won't take me 30 seconds to do with a little script.
                                                                                                    I like pie.

                                                                                                    Comment

                                                                                                    Working...