Ability to remove blank spaces from a string.

  • Profile Image
    NippersD
    Asked on January 04, 2017 at 07:15 PM

    Is there any way to check under conditions to look for when a user types in a blank space?  I need to take two text fields and build an email address from it.  I would like to ultimately remove the blank space before creating the "email address" but if this is not possible, at least be able to put out a message on the form that the user needs to check for an extra space.  please see the attached form.  thanks

  • Profile Image
    liyam
    Answered on January 05, 2017 at 12:51 AM

    Hello NippersD,

    Unfortunately, there is no option to check or trim spaces on fields under conditions. So my suggestion is that if you have a website, you can export your form's full HTML source, place it on a web page and insert there a javascript code that shall validate the input fields trimming leading and trailing spaces.

    If this is not possible for you or if you need assistance, please let us know.

    Thanks.

  • Profile Image
    NippersD
    Answered on January 05, 2017 at 12:24 PM

    Your solution is not possible in my case.  I'd like then to make a developer suggestion:  

    Conditions --> Update / Calculate Field --> Math Functions --> Other Functions

    add the function "TRIM()"

    and/or

    Conditions --> Update / Calculate Field

    allow the ability to look for a blank space as a Value when using STATE = "Contains" and TARGET = "Value" or another field.  If that value or other field could be assigned by default CHAR(32), or " "

     

    thanks for looking into this.

  • Profile Image
    Kevin_G
    Answered on January 05, 2017 at 02:35 PM

    I have checked with some widgets and could not find anything that could help to remove spaces, at least not without using the source code of the form. 

    I will forward this thread to our second level so our developers may consider developing this; however, do note that we cannot provide an ETA or ensure this will be implemented, we will let you know as soon as we get updates regarding this.