16 Replies Latest reply on Mar 5, 2014 9:25 AM by camilo umana

    How to merge alphabetically two lists through a rational solution?

    camilo umana Level 1

      Have two lists of captions it two languages and need to merge alphabetically, but this solution is very poor.

       

      (list x)

      Palacio Imperial, Barcelona, 2012

      Cementerio, 2009

       

      (list y)

      Imperial Palace

      Cemetery

       

      to obtain:

      Palacio Imperial, Barcelona, 2012

      Imperial Palace

       

      Cementerio, 2009

      Cemetery

       

      One method very naive:

       

      · number the lists

      · convert numbering to text

      · in list y add a constant to sort in order:

       

      1. Palacio Imperial, Barcelona, 2012

      2. Cementerio, 2009

      1a. Imperial Palace

      2a. Cemetery

       

      and sort:

      1. Palacio Imperial, Barcelona, 2012

      1a. Imperial Palace

      2. Cementerio, 2009

      2a. Cemetery

       

      delete the code:

       

      Palacio Imperial, Barcelona, 2012

      Imperial Palace

       

      Cementerio, 2009

      Cemetery

       

      (italics are not required)

       

      Thanks.