|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
07-24-2008, 11:55 AM
|
#1 |
|
So Fucking Banned
Join Date: Jan 2007
Posts: 399
|
Is there a script to automatically sort out a list alphabetically
here is the format my links are in:
http://www.freeporn.com/iehwih - Free Porn for you http://www.freeporn.com/8uy98 - A best porn http://www.freeporn.com/qwq23 - Zach porn Is there a way to sort them alphabetically from the beginning of the descriptions, not the link? CF |
|
|
|
07-24-2008, 11:56 AM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Aug 2004
Location: Montreal, Canada
Posts: 5,600
|
mmm Excel?
Put the link in one column, the description in another highlight the entire page and click Data Sort by Column B |
|
|
|
|
07-24-2008, 11:57 AM
|
#3 |
|
Too lazy to set a custom title
Join Date: Feb 2001
Location: Tube Titans, USA
Posts: 11,929
|
http://www.freeporn.com/8uy98 - A best porn
http://www.freeporn.com/iehwih - Free Porn for you http://www.freeporn.com/qwq23 - Zach porn glad I could help
__________________
skype = "adultdatelink" |
|
|
|
|
07-24-2008, 12:31 PM
|
#4 |
|
Confirmed User
Join Date: Apr 2004
Location: Toronto, ON
Posts: 1,706
|
in shell: swap links with descriptions, sort alphabetically, swap back
in php/python/etc: make an array of pairs, sort by description in sql: insert into table, select and order by description excel works too edit: to do it in excel you'll wanna mass replace "-" with "," before opening the file
__________________
 315-310
|
|
|
|
|
07-24-2008, 12:33 PM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Feb 2008
Location: South of the border
Posts: 1,682
|
If you have the links in a list exactly the way you posted (as in, not really in two columns) paste in a text file, and do a replace of " - " for a tab, and then paste it in Excel like Trixxxia said, after sorting, copy again, paste again and replace TAB for " - "
__________________
|
|
|
|
|
07-24-2008, 12:37 PM
|
#6 | |
|
ICQ: 197-556-237
Join Date: Jun 2003
Location: BRASIL !!!
Posts: 57,559
|
Quote:
What she said.
__________________
I'm just a newbie. |
|
|
|
|
|
07-24-2008, 12:45 PM
|
#7 |
|
Confirmed User
Industry Role:
Join Date: Nov 2005
Posts: 8,170
|
Quick PHP solution I wrote for you.
Code:
<?php /** * Link Sort * * @author Fallen Muffin Media <[email protected]> */ $filePath = 'links.txt'; $links = file($filePath); foreach($links as $link) { $linkFrag = explode(' - ', $link); $descArray[] = array($linkFrag[1], $linkFrag[0]); } sort($descArray); for ($i=0;$i<count($descArray);$i++) { echo '<a href='.$descArray[$i][1].'>'.$descArray[$i][0].'</a><br />'; } ?> |
|
|
|
|
07-24-2008, 01:00 PM
|
#8 | |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
Quote:
|
|
|
|
|
|
07-24-2008, 01:54 PM
|
#9 | |
|
Confirmed User
Industry Role:
Join Date: Aug 2004
Location: Montreal, Canada
Posts: 5,600
|
Quote:
 Everyone tells me Access is easier, but for the life of me, I'm lost with it so Excel is my friend. |
|
|
|
|
