topic Re: How do I get rid of extra space when scanning QR code? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718347#M552 <HTML><HEAD></HEAD><BODY><P>If it helps, this is my regular expression:&nbsp;regex(., '^<R>[1-5][1-2][0-9]\d{5}$')</R></P></BODY></HTML> Tue, 30 Jul 2019 18:31:16 GMT JamesKelly4 2019-07-30T18:31:16Z How do I get rid of extra space when scanning QR code? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718346#M551 <HTML><HEAD></HEAD><BODY><P>I have a barcode question on my survey that is a required field, and I have a regular expression that constrains it to a certain length. However, I have gotten a lot of complaints from the field that when they scan the barcode (actually a QR code) it adds a space to the end of the value it retrieved from the barcode. They have to manually delete the extra space before they can successfully submit their record.&nbsp;I am try to minimize data entry time as much as possible.&nbsp; <A href="https://community.esri.com/migrated-users/3263">James Tedrick</A>‌ do you know of a solution for this?</P></BODY></HTML> Tue, 30 Jul 2019 18:16:32 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718346#M551 JamesKelly4 2019-07-30T18:16:32Z Re: How do I get rid of extra space when scanning QR code? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718347#M552 <HTML><HEAD></HEAD><BODY><P>If it helps, this is my regular expression:&nbsp;regex(., '^<R>[1-5][1-2][0-9]\d{5}$')</R></P></BODY></HTML> Tue, 30 Jul 2019 18:31:16 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718347#M552 JamesKelly4 2019-07-30T18:31:16Z Re: How do I get rid of extra space when scanning QR code? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718348#M553 <HTML><HEAD></HEAD><BODY><P><A href="https://community.esri.com/migrated-users/273976">Survey123 Geonet</A>‌ got anything for me? Any help is greatly appreciated!</P></BODY></HTML> Thu, 01 Aug 2019 11:59:07 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718348#M553 JamesKelly4 2019-08-01T11:59:07Z Re: How do I get rid of extra space when scanning QR code? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718349#M554 <HTML><HEAD></HEAD><BODY><P>You could try a calculation like this:</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>if(ends-with(${qrcode}," "),substr(${qrcode},0,string-length(${qrcode})-1),${qrcode})</P></BLOCKQUOTE><P></P><P>Your QRCode question could be flagged to have an esriFieldType of null.</P><P>Then you would add a hidden question and add the calculation above.</P><P></P><P>If you do not want to change the geodatabase schema, then you can do the following:</P><P></P><P>Convert your barcode question into a hidden question and add the calculation above to it.</P><P>Add a new barcode question, set the label and all as you like and MAKE sure you have&nbsp; it as esriFieldType null</P></BODY></HTML> Thu, 01 Aug 2019 12:33:42 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718349#M554 IsmaelChivite 2019-08-01T12:33:42Z Re: How do I get rid of extra space when scanning QR code? https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718350#M555 <HTML><HEAD></HEAD><BODY><P>genius! Thanks a ton!</P></BODY></HTML> Thu, 01 Aug 2019 14:30:15 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-do-i-get-rid-of-extra-space-when-scanning-qr/m-p/718350#M555 JamesKelly4 2019-08-01T14:30:15Z