Learn R Programming

healthyR (version 0.2.2)

sql_mid: Use SQL MID type function

Description

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

Author

Steven P. Sanderson II, MPH

Details

  • You must supply data that you want to manipulate.

See Also

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

Examples

Run this code

sql_mid("this is some text", 6, 2)

Run the code above in your browser using DataLab