Variable Length Vector to Delimited String Array
Posted: Tue Feb 05, 2013 12:15 pm
I have a data in which one column is a vector
data looks like this
[^X 2 4 22 22 19 8 ]
^X is the vector length prefix ( 1 bytes)
the rest are elements of the vector.
Is there any way i can convert the output to a delimited string array ?
Output should be like
'2'|'4'|'22'|'22'|'19'|'8'|
I could do a column export with appropriate delimiter & quote char and use modify stage to remove the 1 byte prefix using spec : substring[1,x](colname), and remove the vector definition from the output column using edit column metadata - but i think its not an elegant way of doing so - even though it seems to achieve the desired result.
data looks like this
[^X 2 4 22 22 19 8 ]
^X is the vector length prefix ( 1 bytes)
the rest are elements of the vector.
Is there any way i can convert the output to a delimited string array ?
Output should be like
'2'|'4'|'22'|'22'|'19'|'8'|
I could do a column export with appropriate delimiter & quote char and use modify stage to remove the 1 byte prefix using spec : substring[1,x](colname), and remove the vector definition from the output column using edit column metadata - but i think its not an elegant way of doing so - even though it seems to achieve the desired result.