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

In toolbox: List, String, and Meta Programming Utility Functions

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
)

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".

Value

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

Examples

quoteText("Sample quotes.")

toolbox documentation built on Sept. 22, 2022, 1:09 a.m.