Excel Report: Is it possible to change the delimiter on the Configurable List data?

  • Sybtain
    Asked on July 25, 2020 at 7:48 AM

    Can I content mask a text field in configurable list to not allow "-" so I can parse the submission data and split by "-"?

    Or, can I specify a delimiter for the submission data?

  • John Support Team Lead
    Replied on July 25, 2020 at 10:16 AM

    Unfortunately, it is not possible to mask the input fields within the configurable list widget. It is currently possible only with the regular input field. Please see the guide below:

    Getting-Started-with-the-Basics-of-Input-Masking

  • SYBTAIN BADAMI
    Replied on July 25, 2020 at 7:48 PM

    Thanks. Any chance the delimiter in the configurable list can be changed from the default "-"?

  • Kevin Support Team Lead
    Replied on July 25, 2020 at 9:34 PM

    May you please provide an example about the delimiter you're referring to? 

    Although may not be possible to change it, we may open a feature request for this. 

    Thanks. 

  • sybtain
    Replied on July 27, 2020 at 5:34 PM

    The delimiter is actually in the submission record where the entire configurable list shows in one excel cell. Each row in submission is separated by \n. However, each field within each row is separated by -. Thus, if the data has a -, the data can't be split out into columns. Would be good to have the ability to specify these delimiters as custom. Meanwhile we have had to use static characters in the Configurable list and style them the same as background to achieve a similar result with double the parsing effort. Thanks.

  • Kevin Support Team Lead
    Replied on July 27, 2020 at 7:32 PM

    Thanks for the additional details. 

    I will be opening the feature request for this, although we cannot provide an ETA, we will keep you updated via this ticket. 

    Thanks.