Jump to content

Concatenate text of multiple records with same Year_OrderNumber


Recommended Posts

  • Newbies

Can someone suggest a calculation or script to concatenate text of multiple records into one string in a single field.

I need to concatenate the description field of all records with the same Year_OrderNumber in a single field.

I attach a sample


Thanks for your support

Test.fmp12

Link to post
Share on other sites
6 minutes ago, anteas1998 said:

concatenate the description field of all records with the same Year_OrderNumber

Sort your records by Year_OrderNumber. Place a summary field defined as List of [ Description ] in a sub-summary by Year_OrderNumber part. This will show all descriptions of the Year_OrderNumber as a return-separated list. If you want another separator, add a calculation field such as =

Substitute ( GetSummary ( sListOfDescriptions ; Year_OrderNumber ) ; ¶ ; ", " )

 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.