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.
