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