topic Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks in ArcGIS Survey123 Questions

Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

PriscilaSamaniego — Wed, 12 Apr 2017 14:38:28 GMT

Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

JamesTedrick — Wed, 12 Apr 2017 16:52:14 GMT

Hi Priscila,

There currently isn't a function that can separate text based on a delimiter in the XLSForm specification. We have given a bit of thought on this, but it will be a while before we approach this with a workaround.

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

HélèneTouyéras — Thu, 09 May 2019 15:31:33 GMT

Hi James,

Do you have any update on this topic?

Our customers would also need us to use this functionnality, to extract fieldworker's initials from their property('username'). The split would then be on the "." character, and we would chain sustr() and split functions.

Many thanks!

Hélène.

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

JamesTedrick — Fri, 10 May 2019 19:56:46 GMT

Hi Hélène,

There is not a function in the XLSForms specification that directly supports this. That being said, it is possible to use a custom JavaScript function (beta functionality documented in the Early Adopter Community) to create a function to split text like the username.

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

HélèneTouyéras — Sat, 11 May 2019 07:31:46 GMT

Many thanks for the fast reply! I will look into this function.

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). Someone knows a expression for this.? Thanks

RonParis — Mon, 17 Jun 2019 15:33:07 GMT

Hi Hélène, did you managed to achieve a workaround using the javascript functionality?

Many thanks

Josh

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). S

Alex_at_Exprodat — Thu, 12 Oct 2023 10:29:29 GMT

@JamesTedrick How long before the substring-before XLSForms function (from ODK, per W3C XForms standard) is implemented into Survey123 Connect? Since custom JavaScript functions cannot be used in public surveys, this would be very helpful as a split/parse function.

Re: Hi, In xlsforms, i am trying to split a string(barcode) by (;) delimiter. I only found a exp for separate by positions substr(${Barcode2},8,25). S

DavidHines — Wed, 20 Apr 2022 18:21:35 GMT

@JamesTedrick Do you have a direct link or name of the Custom Java script example that is used to split text from a multiline question?

Thanks