AnsweredAssumed Answered

how to concatenate with a calculation

Question asked by SarahStacilauskas on Jul 3, 2012
Latest reply on Jul 3, 2012 by philmodjunk

Title

how to concatenate with a calculation

Post

I am not a pro at filemaker but i need to take a text file and import it into filemaker. it has fields called StyleNumber and Page number. i need a formulat to find duplicate stylenumbers and merge them together and then concatenate the page numbers that coorespond to them. for example if i have a style number abc123 and its on page 133 and 144 it needs to ouput like this:

abc123133, 144

 

I am trying this calculation field. but i must be missing something becuase when i export to text file nothing works.

Substitute ( ValueListItems ( Style Number ; Page Number ); "¶"; ",")

Screen_Shot_2012-07-03_at_9.13.48_AM.png

Outcomes