We have an user-entitlement relationship csv file for an application.
This file has two columns userid and accessdata where "accessdata" is a multivalued list of entitlements separated by comma.
We want to parse this data on collection to represent the below one to one user-entitlement relationship
for ex- userid,accessdata
"xyz","ent4" and so on.
But we are unable to do so. The same can be parsed easily if it is a oracle, mysql or ms sql db table/view.
But for csv the parsing fails everytime.