Return to String Function Index
String Function Syntax and Examples
The STRING() function returns the first character in a string, repeated a specified number of times.
Syntax:
STRING(n,string)
where:
n is a positive integer; if 0 is specified, an empty string ('', length=0) will be returned.
Example:input: samplestring,3
IMPORT @sample.dat
{RECORD
{
field1 *,
field2 *\r\n
}
schema1.table1
{
col1 STRING(INT(field2),field1)
col2 STRING(5,(field2))
}}
Results:
schema1.table1.col1 sss schema1.table1.col2 33333
Return to String Function Index