Comparing to a string pattern For a cell that contains string data, you can create a filter condition that compares each value to a string pattern instead of to a specific value. For example, to display only customers whose names start with M, use the Like operator, and specify the string pattern M%, as shown in the following filter condition: Customer Like 'M%' You can use the following special characters in a string pattern: % matches zero or more characters. For example, %ace% matches any value that contains the string ace, such as Ace Corporation, facebook, and Kennedy Space Center. _ matches exactly one character. For example, t_n matches tan, ten, tin, and ton. It does not match teen or tn. To match the percent sign (%) or the underscore character (_) in a string, precede the characters with two backslash characters (\\). For example, to match S_10, use the following string pattern: S\\_10 To match 50%, use the following string pattern: 50\\%
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy