powered by
A utility function to read in a SQL query from a character object, clipboard or text file and remove all comments for use with database query packages
sql_clean(sql)
a cleaned SQL query without comments as a character string
a SQL file or text string
testSQL <- c( "/********* INTRO HEADER COMMENTS", "*********/", " SELECT ", " [VAR 1] -- with comments", ",[VAR 2]",",[VAR 3]", "FROM DATASET ","-- output here") sql_clean(testSQL)
Run the code above in your browser using DataLab