getMatchingColumns: Filter columns by pattern.

Description Usage Arguments See Also

Description

Selects columns with names matching regular expression pattern.

Usage

1
2
getMatchingColumns(pattern, channel, tableName, tableInfo, names.only = TRUE,
  ignore.case = TRUE, invert = FALSE)

Arguments

pattern

character string containing a regular expression to be matched in the given table info.

channel

connection object as returned by odbcConnect. Only used in combination with tableName.

tableName

Aster table name to use. If missing then tableInfo will be used instead.

tableInfo

data frame obtained by calling getTableSummary or sqlColumns.

names.only

logical: if TRUE returns column names only, otherwise full rows of tableInfo.

ignore.case

if TRUE case is ignored during matching, otherwise matching is case sensitive.

invert

logical. if TRUE return columns that do not match.

See Also

grep, getTableSummary


teradata-aster-field/toaster documentation built on May 31, 2019, 8:36 a.m.