INCLUDE()

INCLUDE() returns a variable length string, including only specified characters in the result.

INCLUDE() is the opposite of the EXCLUDE() function.

Function Format

INCLUDE(C1,C2)

INCLUDE() returns a string consisting of only those characters from C1 that appear in C2, in the same order that they appear in C1.

Examples

INCLUDE("123 any street","0123456789")="123"

To create a Prod field that retains only the digits from the Prodno field, specify:

INCLUDE(Prodno,"0123456789")

To specify a long range of consecutive values (numbers or letters) without specifying all values, specify the first and last values separated by a tilde character:

INCLUDE(Prodno,”1~9”)

INCLUDE(ProdDesc,”a~zA~Z”)

To specify the tilde character as one of the values, for example you want to include only the letters A, B, C and tilde, then specify back to back tilde characters:

INCLUDE(ProdDesc,”ABC~~”)

The double tilde causes the tilde to be recognized as a unique value and not a separator of end-points in a range.

Note: Interpretation errors include situations like “z~a”, “9~1”, “~9” or “a~z~1”. In these cases, the string is read as individual characters and not as a range.