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.
Ex- userid,accessdata
"abc","ent1,ent2,ent3"
"xyz","ent4,ent2"
We want to parse this data on collection to represent the below one to one user-entitlement relationship
for ex- userid,accessdata
"abc","ent1"
"abc","ent2"
"abc","ent3"
"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.
Any suggestions.
I asked a similar question a little while back and was given some suggestions to review but no one has said if it is possible with G&L.