Description Usage Arguments Details Value Constraints See Also Examples
Extract sub-strings separated by a delimiter and identified by their position.
1 | FLExtractStr(object, delimiter, stringpos)
|
object |
FLVector of characters |
delimiter |
character |
stringpos |
identifier to reference the sub-string given by its position |
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.
FLVector
row vectors are not supported currently.
substr
, strsplit
for R function reference
implementation.
1 2 3 | widetable <- FLTable("tblstringID", "stringID")
flv <- widetable[1:6,"string"]
resultflvector <- FLExtractStr(flv,"A",1)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.