sql_mid {healthyR}

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

Details

• You must supply data that you want to manipulate.

Author(s)

Steven P. Sanderson II, MPH

See Also

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

Examples

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