Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to sort a list alphabetically but ignore numbers?

  1. Feb 27, 2012 #1
    I have a list of urls I need to sort but I need to sort them only using the letters in the url?

    Eg.

    example.com/174353/a
    example.com/3452344/c
    example.com/435322/d
    example.com/2342/b
    example.com/23456/e

    Would be sorted as:

    example.com/174353/a
    example.com/2342/b
    example.com/3452344/c
    example.com/435322/d
    example.com/23456/e

    Thanks
    AL
     
  2. jcsd
  3. Feb 27, 2012 #2

    jedishrfu

    Staff: Mentor

    if you process the file using the / as a separator then you can extract out the 3rd field to sort on.

    you could probably use awk to do the parsing to write a new file containing the key then url on one line
    then use the sort command to generate a sorted list.

    thats if you're running on linux or some unix variant.
     
  4. Feb 27, 2012 #3
    Most varieties of BASIC have a Right$(,) function, which would read the closing letter(s) off the target string.
     
  5. Feb 27, 2012 #4
    I'm on Ubuntu 11.10.

    The addresses aren't as simple as I thought here's one for example.

    http:// www. flyforums. co.uk/fly-tying-step-step/160-beacon-beige.html

    (The spaces are just there to stop it hyperlinking it.)

    They all follow the same pattern with a number-couple of keywords separated by -s .html
     
  6. Feb 27, 2012 #5

    jedishrfu

    Staff: Mentor

    how about this python script

    http://snippets.dzone.com/posts/show/10115 [Broken]
     
    Last edited by a moderator: May 5, 2017
  7. Feb 27, 2012 #6
    It comes up with an error,

    " File "sort.py", line 3, in <module>
    filename = sys.argv[1]
    IndexError: list index out of range"
     
    Last edited by a moderator: May 5, 2017
  8. Feb 27, 2012 #7
    Please clarify. Would the URL

    http:// www. flyforums. co.uk/fly-tying-step-step/160-beacon-beige.html

    be lexicographically sorted with the value

    httpwwwflyformscoukflytryingstepstepbeaconbeigehtml

    ?
     
  9. Feb 27, 2012 #8

    jedishrfu

    Staff: Mentor

    when you run it you're supposed to provide a file of your urls to be sorted.

    ./sorturls.py myfileofurls.lst

    where sorturls.py is the name of the script and the myfileofurls.lst is your file of unsorted urls.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: How to sort a list alphabetically but ignore numbers?
  1. Sorting techniques (Replies: 6)

Loading...