In colin-fraser/simplesubstitution: Allow of substitution of values into templates.

knitr::opts_chunk$set(echo = TRUE)

Simple Substitutions

Very straightforward substitutions for templating, especially for SQL. Wrap variable names {$like so} in your script and use substitution to substitute values.

library(simplesubstitution)
some_sql <- "SELECT {$column} FROM {$table};"
params <- list(column = "TOOLS", table = "TOOLSHED")
substitution(some_sql, params)

colin-fraser/simplesubstitution documentation built on May 24, 2019, 2:48 p.m.