Learn R Programming

toolbox (version 0.1.1)

quoteText: Add single quotes to strings, useful for converting R strings into SQL formatted strings.

Description

Add single quotes to strings, useful for converting R strings into SQL formatted strings.

Usage

quoteText(
  x,
  char_only = TRUE,
  excluded_chars = c("NULL"),
  null_or_na_as_NULL = TRUE
)

Value

A string, with single quotes added to match PostgreSQL string formatting.

Arguments

x

A string.

char_only

TRUE/FALSE, if TRUE, adds quotes only if is.character(x) is TRUE.

excluded_chars

A character vector, will not add quotes if a value is in excluded_chars.

null_or_na_as_NULL

TRUE/FALSE, if TRUE, NULL and NA values are replaced with the string "NULL".

Examples

Run this code
quoteText("Sample quotes.")

Run the code above in your browser using DataLab