FLExtractStr: Extract parts of strings

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

Extract sub-strings separated by a delimiter and identified by their position.

Usage

FLExtractStr(object, delimiter, stringpos)

Arguments

object	FLVector of characters
delimiter	character
stringpos	identifier to reference the sub-string given by its position

Details

The DB lytix function called is FlExtractStr.The extract string function is a scaler that extracts a segment from a string concatenated with delimiter. The position parameter indicates the location of the delimiter.If the string input doesn't have the delimiter indicated, a null is returned. If the last segment doesn't have a trailing delimiter but the position is indicated, then the last segment is returned.

Value

FLVector

Constraints

row vectors are not supported currently.

See Also

substr , strsplit for R function reference implementation.

Examples

widetable  <- FLTable("tblstringID", "stringID")
flv <- widetable[1:6,"string"]
resultflvector <- FLExtractStr(flv,"A",1)

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.