how to concatenate with a calculation
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:
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 ); "¶"; ",")