Jump to content

Combine Fields with separator ignore empty


This topic is 1752 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

 

textjoin.PNG

Link to comment
Share on other sites

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

 

  • Thanks 1
Link to comment
Share on other sites

This topic is 1752 days old. Please don't post here. Open a new topic instead.

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.