calculation to list field contents if not empty
Okay I would like to write a calculation that would look at a field and get it contents followed by a comma and space unless it is empty, whereas I would want it to grab nothing. How could I write this
Field 1 Field 2 Field 3
Calculation would return
Create a calculation field, result text, unstored, enter the following calculation for as many field as you need. there is a space after the comma
Substitute ( List ( field1; field2; field3; field4 ) ; ¶ ; ", " )
the List creates a return delimited list of the fields that contain data skipping those that are empty, the Substitute function converts the return character to a comma.