Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

is_A1

Test cell reference strings

Description

Test cell reference strings for a specific format.

Usage

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")
is_R1C1("A1")
is_R1C1("R4C12")

x <- c("A1", "$A4", "$b$12", "RC1", "R[-4]C9", "R5C3")
data.frame(x, is_A1(x), is_R1C1(x))
cellranger

Translate Spreadsheet Cell Ranges to Rows and Columns

v1.1.0
MIT + file LICENSE
Authors
Jennifer Bryan [cre, aut], Hadley Wickham [ctb]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.