Combine Fields with separator ignore empty

[ash1474]

I tried few calculation in Filemaker like substitute trim etc but did not get same result.

Google sheets has nice function JOINTEXT any help to replicate/convert the function in Filemaker calculation.

 

[comment]

You can achieve a similar result by using the List() function and substituting the default ¶ delimiter with your own:

Substitute ( List ( Field_A ; Field_B ; Field_C ) ; ¶ ; ";" )

This assumes the fields do not contain any carriage returns - otherwise there will be more work to do.

Note that empty fields will be ignored. If that's not what you want, then just do a straightforward concatenation:

Field_A & ";" & Field_B & ";" & Field_C