DESCRIPTION

The contains() function is used to determine whether or not a text string contains a series of defined characters. If Ninox successfully locates the series of defined characters in the text string, this function will return a “Yes” result. If the “series of defined characters” is not found, this function will return a “No” result.

SYNTAX

  • contains(“text string”,“string to match”)

WHERE

  • contains is the function keyword. This must be entered into the Ninox function editor in all lower-case characters
    “text string” is the string of characters to be searched.
  • “string to match” is the series of characters that Ninox will search for within the “text string”
  • Keep in mind that Ninox will check for an exact match of “string to match” within “text string”. As such, punctuation, spacing and capitalization, or lack thereof, will impact the returned result

EXAMPLE

  • contains(“Ninox Database Solution”,“Ninox”) = “Yes”
  • contains(“Ninox Database Solution”,“NINOX”) = “No”
  • contains(“Ninox Database Solution”,“nox Data”) = “Yes”
  • contains(“Ninox Database Solution”,“nox data”) = “No”
  • contains(“Invoice Total: $4500”,“4500”) = “Yes”

USAGE

Consider a single text field used to store all segments of a mailing address. In this instance, the State component of the address will be embedded inside of a larger text string. In an effort to determine if a specific address is located in a specific state, you can use the contains() function to interrogate the entirety of the text string to see if it contains a specific series of characters as follows:

Question: Is the following address in the State of Ohio? 411 Woody Hayes Dr. Columbus, Ohio 43210?

  • Answer: contains(“411 Woody Hayes Dr. Columbus, Ohio 43210”,“Ohio) = “Yes”
  • Answer: contains(“411 Woody Hayes Dr. Columbus, Ohio 43210”,“OH) = “No”
  • Answer: contains(upper(“411 Woody Hayes Dr. Columbus, Ohio 43210”),“OH”) = “Yes”

SEE ALSO

  • upper()
  • lower()
Revision: 2
Last modified: 2019/11/03

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
For customer support, please contact us here.

Post Comment