Kultgerd

FM 11 Mac List function

Discussion created by Kultgerd on Oct 19, 2015
Latest reply on Oct 26, 2015 by 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

Outcomes