Page 1 of 1

Named value pair data in VARCHAR

Posted: Fri Jun 10, 2016 10:31 pm
by seanarcher7
Hi All,

We are trying to read LONG VAR CHAR data which has named value pair separated by '+' and the columns itself are delimited by semicolon.

For example the column has data like this:

Code: Select all

Sequence+19;Description+SB;OrderStatus+Created

If we pass attribute name as Sequence, then it should return: 19
If we pass attribute name as Description, then it should return: SB
If we pass attribute name as OrderStatus, then it should return: Created.

Please advise if there is any easy way to achieve this

Re: Named value pair data in VARCHAR

Posted: Mon Jun 13, 2016 11:07 pm
by scutter
Already answered in the HP Vertica Community.