How to extract these names? - GoFuckYourself.com

Dirty F · 12-20-2004, 03:27 PM

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 · 12-20-2004, 03:28 PM

no thats impossible

WiredGuy · 12-20-2004, 03:29 PM

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

Naughty · 12-20-2004, 03:29 PM

Quote:

Originally posted by Fake Nick
no thats impossible

No it is not. Somebody with basic php skills can strip everything after the first space

xxxdesign-net · 12-20-2004, 03:29 PM

checkout EXTRACTNAMES 2.3 by Softyfg

polish_aristocrat · 12-20-2004, 03:30 PM

I would do it manually, lol, but probably there's a way.

Fake Nick · 12-20-2004, 03:32 PM

Quote:

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

sorry its impossible

Dirty F · 12-20-2004, 03:33 PM

Quote:

Originally posted by polish_aristocrat
I would do it manually, lol, but probably there's a way.

Where can i send the text file?

Wizzo · 12-20-2004, 03:34 PM

Hey Battuss you got ICQ....

polish_aristocrat · 12-20-2004, 03:34 PM

Quote:

Originally posted by Battuss
Where can i send the text file?

lol, how much are you paying?

Dirty F · 12-20-2004, 03:36 PM

Quote:

Originally posted by Wizzo
Hey Battuss you got ICQ....

Nothing showing up man :/

Whats yer # ?

Wizzo · 12-20-2004, 03:37 PM

117009101

modF · 12-20-2004, 03:39 PM

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

European Lee · 12-20-2004, 03:39 PM

Open the file in notepad.

Search and replace every number with nothing.

Regards,

Lee

polish_aristocrat · 12-20-2004, 03:42 PM

Quote:

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?

r3ap3r · 12-20-2004, 03:45 PM

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

tranza · 12-20-2004, 03:45 PM

Quote:

Originally posted by Battuss
Where can i send the text file?

ztik · 12-20-2004, 03:45 PM

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

pornguy · 12-20-2004, 03:47 PM

Excell will do it with no problem.

Repetitive Monkey · 12-20-2004, 03:47 PM

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.

pornguy · 12-20-2004, 03:49 PM

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!

Fake Nick · 12-20-2004, 03:50 PM

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?

Fake Nick · 12-20-2004, 03:51 PM

Quote:

Originally posted by pornguy
MARY
PATRICIA
LINDA

Told ya!

beat me to it

Trixxxia · 12-20-2004, 03:55 PM

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.

European Lee · 12-20-2004, 03:56 PM

Quote:

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

pornguy · 12-20-2004, 03:57 PM

Just open the txt file in excel, and it will run you trhough the wizzard.

rowan · 12-20-2004, 04:01 PM

Got shell access?

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

edit: haha123 = open brace (above the [ key)

polish_aristocrat · 12-20-2004, 04:05 PM

Quote:

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.

Dirty F · 12-20-2004, 04:09 PM

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.

rowan · 12-20-2004, 04:18 PM

Quote:

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?

Dirty F · 12-20-2004, 04:20 PM

Quote:

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.

Fake Nick · 12-20-2004, 04:21 PM

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

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

that'll be $100 pls

Dirty F · 12-20-2004, 04:24 PM

Quote:

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.

Fake Nick · 12-20-2004, 04:25 PM

Quote:

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

rowan · 12-20-2004, 04:26 PM

Quote:

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.

Dirty F · 12-20-2004, 04:26 PM

Quote:

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.

Moreno · 12-20-2004, 04:29 PM

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

Funky Bastard · 12-20-2004, 04:30 PM

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

BackToMine · 12-20-2004, 04:33 PM

Quote:

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!

Fred Quimby · 12-20-2004, 04:34 PM

i use excel for stuff like that

pornJester · 12-20-2004, 04:36 PM

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.

Dirty F · 12-20-2004, 04:36 PM

Quote:

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.

Repetitive Monkey · 12-20-2004, 04:37 PM

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

Fake Nick · 12-20-2004, 04:37 PM

Quote:

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

Dirty F · 12-20-2004, 04:40 PM

Ok, that worked, thanks peeps.

Dirty F · 12-20-2004, 04:40 PM

Quote:

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

:/

Repetitive Monkey · 12-20-2004, 04:42 PM

Quote:

Originally posted by Battuss
:/

What? Why?

Dirty F · 12-20-2004, 04:52 PM

Quote:

Originally posted by Repetitive Monkey
What? Why?

Nothing man haha.

bryc · 12-20-2004, 05:14 PM

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

Hit me on icq 209182384

Babaganoosh · 12-20-2004, 05:16 PM

Quote:

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.

12-20-2004, 03:27 PM	#1
Dirty F Too lazy to set a custom title Industry Role: Join Date: Jul 2001 Posts: 59,204	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?

12-20-2004, 03:29 PM	#3
WiredGuy Pounding Googlebot Industry Role: Join Date: Aug 2002 Location: Canada Posts: 34,486	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 __________________ I play with Google. Last edited by WiredGuy; 12-20-2004 at 03:30 PM..

12-20-2004, 03:30 PM	#6
polish_aristocrat Too lazy to set a custom title Join Date: Jul 2002 Posts: 40,377	I would do it manually, lol, but probably there's a way. __________________ I don't use ICQ anymore.

12-20-2004, 03:34 PM	#9
Wizzo 2011 GFY Hall of Fame! Industry Role: Join Date: Nov 2000 Location: Back in Texas! Posts: 15,224	Hey Battuss you got ICQ.... __________________ Looking for Opportunity!

12-20-2004, 03:37 PM	#12
Wizzo 2011 GFY Hall of Fame! Industry Role: Join Date: Nov 2000 Location: Back in Texas! Posts: 15,224	117009101 __________________ Looking for Opportunity!

12-20-2004, 03:28 PM	#2
Fake Nick So Fucking Banned Join Date: Jul 2004 Location: go troll goo! Posts: 7,708	no thats impossible

12-20-2004, 03:29 PM	#5
xxxdesign-net My hips don't lie Industry Role: Join Date: Nov 2002 Posts: 10,129	checkout EXTRACTNAMES 2.3 by Softyfg

12-20-2004, 03:39 PM	#13
modF Confirmed User Join Date: Aug 2002 Posts: 1,888	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

12-20-2004, 03:39 PM	#14
European Lee Confirmed User Join Date: Dec 2002 Location: Daytona Beach Posts: 7,133	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

12-20-2004, 03:45 PM	#16
r3ap3r Confirmed User Join Date: Jul 2004 Location: Canada Posts: 3,535	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

12-20-2004, 03:45 PM	#18
ztik Confirmed User Industry Role: Join Date: Aug 2001 Location: Nomad Posts: 5,196	Import it into microsoft excel from text and make each colum seperated by a Space Copy the colums you want to another file

12-20-2004, 03:47 PM	#19
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	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!

12-20-2004, 03:47 PM	#20
Repetitive Monkey Confirmed User Join Date: Feb 2004 Posts: 3,505	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.

12-20-2004, 03:49 PM	#21
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	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!

12-20-2004, 03:50 PM	#22
Fake Nick So Fucking Banned Join Date: Jul 2004 Location: go troll goo! Posts: 7,708	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?

12-20-2004, 03:55 PM	#24
Trixxxia Confirmed User Industry Role: Join Date: Aug 2004 Location: Montreal, Canada Posts: 5,600	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.

12-20-2004, 03:57 PM	#26
pornguy Too lazy to set a custom title Industry Role: Join Date: Mar 2003 Location: Homeless Posts: 62,911	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!

12-20-2004, 04:01 PM	#27
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	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 at 04:02 PM..

12-20-2004, 04:09 PM	#29
Dirty F Too lazy to set a custom title Industry Role: Join Date: Jul 2001 Posts: 59,204	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.

12-20-2004, 04:21 PM	#32
Fake Nick So Fucking Banned Join Date: Jul 2004 Location: go troll goo! Posts: 7,708	http://www.latinapussy.info/names1.txt http://www.latinapussy.info/names2.txt that'll be $100 pls

12-20-2004, 04:29 PM	#37
Moreno Registered User Join Date: Dec 2004 Posts: 95	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

12-20-2004, 04:30 PM	#38
Funky Bastard So Fucking Banned Join Date: Nov 2004 Location: San Antonio, Texas Posts: 2,544	Humm I can do that with emails and domains but nope not what you want!

12-20-2004, 04:34 PM	#40
Fred Quimby Confirmed User Join Date: Jul 2004 Location: Long Island, NY Posts: 5,430	i use excel for stuff like that __________________

12-20-2004, 04:36 PM	#41
pornJester Confirmed User Join Date: Mar 2001 Location: Florida Posts: 6,138	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

12-20-2004, 04:37 PM	#43
Repetitive Monkey Confirmed User Join Date: Feb 2004 Posts: 3,505	I already posted the code, it isn't good enough?

12-20-2004, 04:40 PM	#45
Dirty F Too lazy to set a custom title Industry Role: Join Date: Jul 2001 Posts: 59,204	Ok, that worked, thanks peeps.

12-20-2004, 05:14 PM	#49
bryc Confirmed User Join Date: Apr 2001 Posts: 102	you got that all sorted out now Battus? If not I know a free tool that may help ya... Hit me on icq 209182384