gsubfn: Helper function for read.csv.sql

In alyssafrazee/read.csv.sql: the read.csv.sql function from sqldf, minus the Tcl/tk dependency

Description

see gsubfn in sqldf package - this function is equivalent, but functionality requiring tcltk has been removed.

Usage

gsubfn(pattern, replacement, x, backref, USE.NAMES = FALSE,
  ignore.case = FALSE, env = parent.frame(), ...)

Arguments

pattern	Same as pattern in gsub
replacement	A character string, function, list, formula or proto object. See Details.
x	Same as x in gsub
backref	Number of backreferences to be passed to function. If zero or positive the match is passed as the first argument to the replacement function followed by the indicated number of backreferences as subsequent arguments. If negative then only the that number of backreferences are passed but the match itself is not. If omitted it will be determined automatically, i.e. it will be 0 if there are no backreferences and otherwise it will equal negative the number of back references. It determines this by counting the number of non-escaped left parentheses in the pattern. Also if the function contains an ampersand as an argument then backref will be taken as non-negative and the ampersand argument will get the full match.
USE.NAMES	See USE.NAMES in sapply
ignore.case	If TRUE then case is ignored in the pattern argument.
env	Environment in which to evaluate the replacement function. Normally this is left at its default value.
...	Other gsub arguments

Details

If replacement is a string then it acts like gsub. If replacement is a function then each matched string is passed to the replacement function and the output of that function replaces the matched string in the result. The first argument to the replacement function is the matched string and subsequent arguments are the backreferences, if any. If replacement is a list then the result of the regular expression match is, in turn, matched against the names of that list and the value corresponding to the first name in the list that is match is returned. If there are no names matching then the first unnamed component is returned and if there are no matches then the string to be matched is returned. If backref is not specified or is specified and is positive then the entire match is used to lookup the value in the list whereas if backref is negative then the identified backreference is used. If replacement is a formula instead of a function then a one line function is created whose body is the right hand side of the formula and whose arguments are the left hand side separated by + signs (or any other valid operator). The environment of the function is the environment of the formula. If the arguments are omitted then the free variables found on the right hand side are used in the order encountered. 0 can be used to indicate no arguments. letters, LETTERS and pi are never automatically used as arguments. If replacement is a proto object then it should have a fun method which is like the replacement function except its first argument is the object and the remaining arguments are as in the replacement function and are affected by backref in the same way. gsubfn automatically inserts the named arguments in the call to gsubfn into the proto object and also maintains a count variable which counts matches within strings. The user may optionally specify pre and post methods in the proto object which are fired at the beginning and end of each string (not each match). They each take one argument, the object. Note that if backref is non-negative then internally the pattern will be parenthesized. A utility function cat0 is available. They are like cat and paste except that their default sep value is "".

Value

as in gsub

Author(s)

G. Grothendieck

See Also

strapply

alyssafrazee/read.csv.sql documentation built on May 12, 2019, 2:31 a.m.