Use SQL MID type function

Perform an SQL SUBSTRING type function

Usage

sql_mid(.text, .start_num, .num_char)

Arguments

.text

A piece of text/string to be manipulated

.start_num

What place to start at

.num_char

How many characters do you want to grab

Details

• You must supply data that you want to manipulate.

See also

Other Utilities: opt_bin(), save_to_excel(), sql_left(), sql_right()

Author

Steven P. Sanderson II, MPH

Examples

sql_mid("this is some text", 6, 2)
#> [1] "is"