![]() |
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? |
no thats impossible
|
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 |
Quote:
|
checkout EXTRACTNAMES 2.3 by Softyfg
|
I would do it manually, lol, but probably there's a way.
|
Quote:
sorry its impossible |
Quote:
|
Hey Battuss you got ICQ....:winkwink:
|
Quote:
|
Quote:
Whats yer # ? |
117009101
|
Open it in excel, text to colums by a delimited space and then just delete the other colums. Done and done.
|
Open the file in notepad.
Search and replace every number with nothing. Regards, Lee |
Quote:
edited - i did what you said, I open the replace feature, but how do i replace all numbers? |
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 :winkwink:
|
Quote:
|
Import it into microsoft excel from text and make each colum seperated by a Space Copy the colums you want to another file
|
Excell will do it with no problem.
|
Monkey to the rescue!
PHP Code:
|
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! |
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? |
Quote:
beat me to it :Graucho |
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.
|
Quote:
http://www.gaywidewebmasters.com/gfysr.jpg Put a number in the top field, leave the second field blank then hit 'Replace All' Regards, Lee |
Just open the txt file in excel, and it will run you trhough the wizzard.
|
Got shell access?
cat file.txt | awk '{print $1}' > newfile.txt edit: haha123 = open brace (above the [ key) |
Quote:
|
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. |
Quote:
|
Quote:
|
|
Quote:
You should know that. |
Quote:
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 |
Quote:
|
Quote:
And dont worry, i didnt even click the files. |
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 |
Humm I can do that with emails and domains but nope not what you want!
|
Quote:
Only reason I have Excel installed! |
i use excel for stuff like that
|
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.
|
Quote:
|
I already posted the code, it isn't good enough?
|
Quote:
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 :1orglaugh |
Ok, that worked, thanks peeps.
|
Quote:
|
Quote:
|
Quote:
|
you got that all sorted out now Battus? If not I know a free tool that may help ya...
Hit me on icq 209182384 |
Quote:
|
| All times are GMT -7. The time now is 03:07 AM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123