Skip to content

Detect a pattern in the same way as SQL's LIKE operator

Source: R/detect.R
str_like.Rd

str_like() follows the conventions of the SQL LIKE operator:

  • Must match the entire string.

  • _ matches a single character (like .).

  • % matches any number of characters (like .*).

  • \% and \_ match literal % and _.

  • The match is case insensitive by default.

Usage

str_like(string, pattern, ignore_case = TRUE)

Arguments

string

Input vector. Either a character vector, or something coercible to one.

pattern

A character vector containing a SQL "like" pattern. See above for details.

ignore_case

Ignore case of matches? Defaults to TRUE to match the SQL LIKE operator.

Value

A logical vector the same length as string.

Examples

fruit <- c("apple", "banana", "pear", "pineapple")
str_like(fruit, "app")
#> [1] FALSE FALSE FALSE FALSE
str_like(fruit, "app%")
#> [1]  TRUE FALSE FALSE FALSE
str_like(fruit, "ba_ana")
#> [1] FALSE  TRUE FALSE FALSE
str_like(fruit, "%APPLE")
#> [1]  TRUE FALSE FALSE  TRUE