3 Replies Latest reply on Oct 26, 2015 4:10 AM by Kultgerd

    FM 11 Mac List function

    Kultgerd

      Hi,

      I need a list of colours GER;FRA (german;french) for each catalogue page.

      If I am using the list(field) function, I get all colours including duplicates.

       

      I'd need every colour only 1 time. I have created a self join relation based on season, catalogue number and page.

       

      I need it for automatic translation in QuarkXPress via integrated AppleScript. AppleScript would call this list and translate all colours for the actual page as an array. This is fast and save. We have tested it with a static colour list.

       

      Does anyone knows how to get each colour name only a single time (just as the SQL "group by" function)?

       

      Example of the german colours:

      weiß-rosé

      weiß-rosé

      weiß-anthrazit

      weiß-anthrazit

      weiß

      weiß

      schwarz-rosé

      schwarz

      schwarz

      schwarz

       

      Needed as (if I know how to get this result, it's easy to add ";french_colour"):

      weiß-rosé

      weiß-anthrazit

      weiß

      schwarz-rosé

      schwarz


      Cheers

      Gerd