topic Automatically remove spaces and special characters in Survey123 in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824147#M16516 <HTML><HEAD></HEAD><BODY><P>I have a form with two fields, or at least 2 of interest.&nbsp; One (Facility_Name) is a text field that the user inputs the facility name (i.e. Place's Name).&nbsp; I have another field in which I am trying to create a file name of sorts (FileName).&nbsp; This field needs to take the Facility_Name information and put it into the file name without spaces or special characters (i.e. PlacesName).&nbsp; The names are not consistent format, so I can't use something like the substr function.&nbsp;Is there a formula or other way to do this?&nbsp;&nbsp;I haven't been able to find one.&nbsp; Thanks.</P></BODY></HTML> Thu, 30 Aug 2018 21:28:20 GMT BrandonA_CDPH 2018-08-30T21:28:20Z Automatically remove spaces and special characters in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824147#M16516 <HTML><HEAD></HEAD><BODY><P>I have a form with two fields, or at least 2 of interest.&nbsp; One (Facility_Name) is a text field that the user inputs the facility name (i.e. Place's Name).&nbsp; I have another field in which I am trying to create a file name of sorts (FileName).&nbsp; This field needs to take the Facility_Name information and put it into the file name without spaces or special characters (i.e. PlacesName).&nbsp; The names are not consistent format, so I can't use something like the substr function.&nbsp;Is there a formula or other way to do this?&nbsp;&nbsp;I haven't been able to find one.&nbsp; Thanks.</P></BODY></HTML> Thu, 30 Aug 2018 21:28:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824147#M16516 BrandonA_CDPH 2018-08-30T21:28:20Z Re: Automatically remove spaces and special characters in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824148#M16517 <HTML><HEAD></HEAD><BODY><P>Hi Brandon,</P><P></P><P>There isn't a built-in XLSForm function that would do what you are asking; however, there is a feature (custom JS functions) in beta on the <A href="https://earlyadopter.esri.com/project/article/item.html?cap=e69ef91f45744b98882c651f7b518eb7&amp;arttypeid={5a8e51ed-4a87-43fe-a67d-2b7829af130f}&amp;artid={D2F0ED6D-1ADC-43EF-8A87-FCCF09381DB3}">Early Adopter Community</A> that could address this.</P></BODY></HTML> Thu, 30 Aug 2018 21:31:36 GMT https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824148#M16517 JamesTedrick 2018-08-30T21:31:36Z Re: Automatically remove spaces and special characters in Survey123 https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824149#M16518 <HTML><HEAD></HEAD><BODY><P>Okay, thank you for the info. Glad I’m not going crazy. ☺</P></BODY></HTML> Thu, 30 Aug 2018 21:33:42 GMT https://community.esri.com/t5/arcgis-survey123-questions/automatically-remove-spaces-and-special-characters/m-p/824149#M16518 BrandonA_CDPH 2018-08-30T21:33:42Z