AnsweredAssumed Answered

Automatically remove spaces and special characters in Survey123

Question asked by brandon.adcock_CDPHDATA on Aug 30, 2018
Latest reply on Aug 30, 2018 by brandon.adcock_CDPHDATA

I have a form with two fields, or at least 2 of interest.  One (Facility_Name) is a text field that the user inputs the facility name (i.e. Place's Name).  I have another field in which I am trying to create a file name of sorts (FileName).  This field needs to take the Facility_Name information and put it into the file name without spaces or special characters (i.e. PlacesName).  The names are not consistent format, so I can't use something like the substr function. Is there a formula or other way to do this?  I haven't been able to find one.  Thanks.