Solved: Looking for opposite of split()

Erik_Ferm · 09-15-2020 11:08 AM

Hi,

I am still pretty new to Appsheet so sorry if I have missed this. I am looking to send an email to 1 or two users whose emails will be in child records of the table where the send email action goes.

I can get the list of emails using the virtual column pointing to the child records. However, this returns a list.

For the start email action to work, I need a string containing the emails separated by semi colon like “email1@domain.com ; email2@domain.com”.

So I am looking for a function doing the opposite of SPLIT() but I can’t find one. In PHP. split is the same as explode() so I guess I am looking for implode().

I think it can be done using CONCATENATE and sorted SELECT statements but it seems a bit cumbersome, in particular if you don’t know if you have 1, 2 or 3 child records.

Is there an easy way to do this?

Steve

That’s the way to do it. CONCATENATE() will produce a comma-separated Text value. If you need semicolons instead, wrap CONCATENATE() with SUBSTITUTE():

SUBSTITUTE(
  CONCATENATE(
    SORT(
      UNIQUE(
        [Related child-columns][email-column]
      )
    )
  ),
  ",",
  ";"
)

See also:

View solution in original post

Steve

That’s the way to do it. CONCATENATE() will produce a comma-separated Text value. If you need semicolons instead, wrap CONCATENATE() with SUBSTITUTE():

SUBSTITUTE(
  CONCATENATE(
    SORT(
      UNIQUE(
        [Related child-columns][email-column]
      )
    )
  ),
  ",",
  ";"
)