Test cell reference strings

Source: R/A1-R1C1-regex-utils.R

Test cell reference strings for a specific format.

is_A1(x)

is_R1C1(x)

Arguments

x

character vector of cell reference strings

Value

a logical vector

Functions

  • is_A1: A1 format, case insenstive; relative, absolute, or mixed

  • is_R1C1: R1C1 format; relative, absolute, or mixed

Examples

is_A1("A1")
#> [1] TRUE
is_R1C1("A1")
#> [1] FALSE
is_R1C1("R4C12")
#> [1] TRUE

x <- c("A1", "$A4", "$b$12", "RC1", "R[-4]C9", "R5C3")
data.frame(x, is_A1(x), is_R1C1(x))
#>         x is_A1.x. is_R1C1.x.
#> 1      A1     TRUE      FALSE
#> 2     $A4     TRUE      FALSE
#> 3   $b$12     TRUE      FALSE
#> 4     RC1     TRUE       TRUE
#> 5 R[-4]C9    FALSE       TRUE
#> 6    R5C3    FALSE       TRUE