I am trying to copy part of an excel cell and paste it into an application. I think I need to get a substring of the cell and build a datatable in order to do a for each. because I need each word to paste in the application one by one but I am not sure how to do it. Here is a copy of the cell:
Role ID: 454969 Group: AAA User: THHEOHE, THBWDT, BHWITHE, HGHDH, THUEYT, THPWOE, WHGGWU, WHOSLKD, WBHHOEL, BHHOW
So I need to get just the contents of everything after “User:” . Each acronym needs to be inputed one by one into a screen (I would use a for each).
Thanks for anyones input