powered by
Perform an SQL SUBSTRING type function
sql_mid(.text, .start_num, .num_char)
A piece of text/string to be manipulated
What place to start at
How many characters do you want to grab
Steven P. Sanderson II, MPH
You must supply data that you want to manipulate.
Other Utilities: opt_bin(), save_to_excel(), sql_left(), sql_right()
opt_bin()
save_to_excel()
sql_left()
sql_right()
sql_mid("this is some text", 6, 2)
Run the code above in your browser using DataLab