SPLIT_TO_RECORD
Returns the given string split by the provided delimiter.
Syntax
Arguments
Examples
Transformation job example
SQL
Query result
Last updated
Name | Type | Description | Default Value |
---|---|---|---|
fieldNames | splitBy | filterEmptyValues | value | Output |
---|---|---|---|---|
fieldNames | splitBy | filterEmptyValues | value | Output |
---|---|---|---|---|
fieldNames
string
splitBy
string
','
filterEmptyValues
boolean
false
value
string
'a,b,c'
','
false
'1,2,3,4'
{a: 1
, b: 2
, c: 3
}
'a,b,c'
','
false
'1,2'
{a: 1
, b: 2
, c: ``}
'a,b,c'
','
true
'1,,3'
{a: 1
, b: ``, c: 3
}
'a,b,c'
','
false
'1,2,3,4'
{a: 1
, b: 2
, c: 3
}