Back

If your email is not recognized and you believe it should be, please contact us.

  • You must be logged in to reply to this topic.Login

Alphabetically order by last names

Return to Member Forum

  • Author
    Posts
    • #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!

    • #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.

    • #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

    • #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 ?

Viewing 3 reply threads
  • The forum ‘General InDesign Topics (CLOSED)’ is closed to new topics and replies.
Forum Ads