Is there a script to automatically sort out a list alphabetically

**Trixxxia** · 07-24-2008, 10:56 AM

mmm Excel?

Put the link in one column, the description in another
highlight the entire page and click Data Sort by Column B

**ADL Colin** · 07-24-2008, 10:57 AM

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

**Linguist** · 07-24-2008, 11:31 AM

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

**AnniKN** · 07-24-2008, 11:33 AM

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 " - "

**tranza** · 07-24-2008, 11:37 AM

Originally posted by Trixxxia

mmm Excel?

Put the link in one column, the description in another
highlight the entire page and click Data Sort by Column B

What she said.

**fallenmuffin** · 07-24-2008, 11:45 AM

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 />';
}

?>

**Antonio** · 07-24-2008, 12:00 PM

Originally posted by AnniKN

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 " - "

that's what I do all the time (importing fhgs with descriptions and thumbs) but I use Access, it feels so much easier but that's probably besause I'm not too familiar with Excel, I've tried it a few times but it looks pretty awkward

**Trixxxia** · 07-24-2008, 12:54 PM

Originally posted by Antonio

that's what I do all the time (importing fhgs with descriptions and thumbs) but I use Access, it feels so much easier but that's probably besause I'm not too familiar with Excel, I've tried it a few times but it looks pretty awkward

**oops forgot the put in the replace part

Everyone tells me Access is easier, but for the life of me, I'm lost with it so Excel is my friend.

Is there a script to automatically sort out a list alphabetically

Is there a script to automatically sort out a list alphabetically

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment