This is my string which is returned from DB,
"N,591;F\"Vendor Number\",86;F\"Vendor Name\",143;F\"Claim Number\",82;"
and stored in string columns,
I want to extract 'Vendor Number','Vendor Name' and 'Claim Number'..Any ideas how I can do that? Thanks...
This ought to do it:
Output:
If the number of column labels is not known, choose every alternate index.