String from XML?

[pctechtv]

After combining the JSON results I was able to use the findrx function to get pretty close.
 

Code:

Copy      Help

s1 = F"{{''playlist'': {json1}, ''status'': {json2}}"

str pat1 rx1 sub1 pat2 rx2 sub2
pat1 = "''time'':\d+"
rx1 = findrx(s1 pat1 0 1 sub1)
pat2 = "''uri''\s*:\s*''([^'']+)''[^}]*?''current''\s*:\s*''current''"
rx2 = findrx(s1 pat2 0 1 sub2)

out rx1
out sub1
out sub2

Even though I could work with this result in my target app, I would like to refine (clean perfectly) the result in to somthing like so:
 

Code:

Copy      Help

120,D:/Sandbox/Test%20Work/250529%20_SNA_MIA_SDQ_Workspace/Trip%20Full%20Pics/IMG_005662.mp4
88,D:/Sandbox/Test%20Work/250529%20_SNA_MIA_SDQ_Workspace/Trip%20Full%20Pics/IMG_005782.mp4
321,D:/Sandbox/Test%20Work/250529%20_SNA_MIA_SDQ_Workspace/Trip%20Full%20Pics/IMG_005259.mp4

Or construct a JSON like output, because my target app will work well with that. Thanks for any help