Custom deliminator for multiselect text field
I have a multiselect text field that I need to use as a source for a system that requires a specific deliminator between strings. I need a way to change the semicolon that is normally returned between selections in a multiselect field with another character.
For example, a multiselect field with the following options selected
returns "Alpha;Beta;Gamma;Delta", but I need it to return "Alpha/Beta/Gamma/Delta".
As far as I can tell, there is no string substitution function in formula fields. I tried using the List() function, but it does not accept a multiselect field as a source. I have some variability in the options for the multiselect field, so doing something like the example below is not ideal:
Ideally, I would like to directly replace semicolons with another character in the text field. Failing that, I would like to be able to format the multiselect field in such a way that the List() function will allow it as input.
For example, a multiselect field with the following options selected
- Alpha
- Beta
- Gamma
- Delta
returns "Alpha;Beta;Gamma;Delta", but I need it to return "Alpha/Beta/Gamma/Delta".
As far as I can tell, there is no string substitution function in formula fields. I tried using the List() function, but it does not accept a multiselect field as a source. I have some variability in the options for the multiselect field, so doing something like the example below is not ideal:
List("/", If(Contains([Multiselect field], "Alpha"), "Alpha", ""),If(Contains([Multiselect field], "Beta"), "Beta", ""),
If(Contains([Multiselect field], "Gamma"), "Gamma", ""),
If(Contains([Multiselect field], "Delta"), "Delta", ""))
Ideally, I would like to directly replace semicolons with another character in the text field. Failing that, I would like to be able to format the multiselect field in such a way that the List() function will allow it as input.
