Discussions

Expand all | Collapse all

Custom deliminator for multiselect text field

  • 1.  Custom deliminator for multiselect text field

    Posted 02-19-2019 18:52
    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

    •     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.


  • 2.  RE: Custom deliminator for multiselect text field

    Posted 02-19-2019 19:24
    Hi. We have a SearchandReplace() function coming in this release. Please see our February release notes for details.