Exact match in string array

  • Resolved tanydrej0

    (@tanydrej0)


    3 years ago

    Hello, I would like to create a simple function which will be able to verify in an array of string the exact correspondence of the value entered by the user.

    Here is an example, however it returns true as soon as a letter matches the string

    IF(IN(fieldname2, ["Ramecourt", "Saint-Pol"]), "ZONE 1", "ZONE INCONNUE")

    –> If user type : “R” it returns true = “ZONE 1”
    –> User needs to type “Ramecourt” or “Saint-Pol” or “ramecourt” for a valid return…

    Can you help me people?
    Thanks a lot

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @tanydrej0

    Please, indicate the URL to the page with the form to check the equation in action.

    Best regards.

    Thread Starter tanydrej0

    (@tanydrej0)

    I am currently using a local server to develop my website …
    Thank you for your quick reply

    Plugin Author codepeople

    (@codepeople)

    Hello @tanydrej0

    Please, edit the equation as follows:

    IF(OR(fieldname2=="Ramecourt", fieldname2=="Saint-Pol"), "ZONE 1", "ZONE INCONNUE")

    Best regards.

    Thread Starter tanydrej0

    (@tanydrej0)

    @codepeople
    Thanks you sir it’s working.

    Best regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Exact match in string array’ is closed to new replies.