Use SQL LEFT, MID and RIGHT type functions

Source: R/sql_string_split.R

perform either left, mid or right substring sql like manipulations

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 and substrig.

Examples


mid("this is some text", 3, 5)

#> [1] "is is"