OCR list of values to use in loop

Hi,
I’m looking for a way that OCR in UI.Vision would import list of values, which could be used for UI.Visions’ “loop” (with or without csv in between).

My background - I have to do periodic report with user list and assigned roles (app doesn’t provide that functionality). Each list of roles are listed in extra window that appears, when username is selected, as it’s a link.

As this is internal, I cannot share any screenshots or URLs, therefore let’s try with what’s available on the internet:

Imagine here’s list of users (as it will look similar to this screenshot) that were added to application. There are 4 columns - “username”,“description”,“last login” and “last logout”.
My idea is to load from column “users” everything using OCR, then make loop from it. I need a loop as each username row, so automation could click a link that opens extra window with all the details.

As everything’s here in javascript and loaded dynamically, it’s hard to point what UI.Vision should look at, threat as “static value” and also be an element that would open “extra window”. Right now I’m using “linkText=username” but this is static and will break when there’s new user or another was deleted.

That’s why I’m trying with OCR, as tests confirmed, it was able to load all users at once to UI.Vision. Problem is, as what OCR loads to variable as value, was copied literally, so including “end of line” characters. That results in situation when in “value” cell for, variable, I see “username\r\nusername1\r\nusername2\r\nandsoon”. That isn’t readable in any way by CSV or loop, so instead of going one username at time, it tries to load whole list at once.
The only way I was able to convert, was using Notepad++ where I could remove “end of line” characters and put them again in correct format.

In summary, is it possible to configure UI.Vision script, to have data loaded correctly, or any workaround for this?

Thanks in advance for any help.

So the goal is to click a link in each row?

That sounds like something that some Javascript inside the executeScriptSandbox command can do.