1 | parseSQL(fileLoc)
|
fileLoc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | ##---- Should be DIRECTLY executable !! ----
##-- ==> Define data, use random,
##-- or do help(data=index) for the standard data sets.
## The function is currently defined as
function (fileLoc)
{
sqlParsed <- readLines(fileLoc, warn = FALSE)
sqlParsed <- gsub("\--(.*)", "", sqlParsed, perl = TRUE)
sqlParsed <- gsub("\t", " ", sqlParsed, perl = TRUE)
sqlParsed <- paste(sqlParsed, collapse = " ")
sqlParsed <- gsub("(/\*)+?[\w\W]+?(\*/)", "", sqlParsed,
perl = TRUE)
sqlParsed <- gsub("\s\s+", " ", sqlParsed, perl = TRUE)
return(sqlParsed)
}
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.