fatalcore
04-27-2020, 07:37 PM
Hi Friends
Can someone please help me with a VBA code. I have three to four tabs each containing approx 20-35 rows of this data
{ "user" : "DC=Certificate Manager,O=Test Inc.,OU=QA:dc.group.1339956,CN=vid,UID=identity:dc.group.1359009", "roles" : [ { "role" : "QA", "db" : "admin" }, { "role" : "Test", "db" : "admin" }, { "role" : "ADMIN", "db" : "admin" } ] }
Can somebody help me out with a vba code to trim the above line to this
{ "user" : "DC=Certificate Manager,O=Test Inc.,OU=QA:dc.group.1339956,CN=vid,UID=identity:dc.group.1359009" }
Currently I am manually doing this, I am searching ", "roles" : " and manually replacing with " }%", then doing a text to column, applying delimiter as % . I tried recording a macro and my excel crashed I will really appreciate if someone can help me.
Thanks,
Can someone please help me with a VBA code. I have three to four tabs each containing approx 20-35 rows of this data
{ "user" : "DC=Certificate Manager,O=Test Inc.,OU=QA:dc.group.1339956,CN=vid,UID=identity:dc.group.1359009", "roles" : [ { "role" : "QA", "db" : "admin" }, { "role" : "Test", "db" : "admin" }, { "role" : "ADMIN", "db" : "admin" } ] }
Can somebody help me out with a vba code to trim the above line to this
{ "user" : "DC=Certificate Manager,O=Test Inc.,OU=QA:dc.group.1339956,CN=vid,UID=identity:dc.group.1359009" }
Currently I am manually doing this, I am searching ", "roles" : " and manually replacing with " }%", then doing a text to column, applying delimiter as % . I tried recording a macro and my excel crashed I will really appreciate if someone can help me.
Thanks,