CreativePro Forum

Return to Member Forum

• Author
  Posts
• • March 22, 2016 at 10:55 am #83217
    Curtis Sharp

    Member

    Is there a way to Sort/arrange in alphabetical order by ‘last names’? I ran a script to Sortparagrah, but I need to have the alphabetical order be by last name. Thank you!

  • March 22, 2016 at 1:54 pm #83219
    Anonymous

    Inactive

    Select the list of people then choose Convert To Table. Instead of a Tab use a Space. Just type it in there.

    Might need to merge some cells where it’s Paddy Mc Nair etc.

    Once done swap you’re right column with the left with a drag and drop.

    Convert table to text

    Run sort paragraph

    And reverse theprocess.

    Sounds long but it is quite quick.

  • March 23, 2016 at 10:11 am #83288
    Peter Kahrel

    Participant

    No need for a table. Use a GREP to place the last names before the first names, sort the list, then use another GREP to place the last names after the first names:

    Find what: ^(.+?) (.+)
    Change to: $2@$1

    Sort the list

    Find what: ^(.+)@(.+)
    Change to: $2 $1

    Breakdown:

    ^ Start of paragraph
    (.+?) Match and capture up to (the first space)
    Match the first space
    (.+) Match and capture the rest of the paragraph

    Peter

  • March 24, 2016 at 6:44 am #83358
    Anonymous

    Inactive

    Conversely there’s no need for GREP…

    Was on tablet device and hard enough to type grep at the computer never mind on touch screen ?

• Author
  Posts