Extract String After a Specific Character in RG

[cinji18]

Hi, everyone:

So I was able to use Split By to separate a JSON string and display each key-value pair in a repeating group:

But what I really need is to display only the values, not the key. When I tried to use Split By again, it alternated the keys and values (which I suspected would happen):

I only want the values (2nd, 4th, 6th, etc.) cells. How do I do that? Would I be better off doing regex (which I am not familiar with)?

Any advice would be great.

Thank you.

[mani2726]

You can use regular expressions to extract the data.

[cinji18]

Hi, Mani:

I have tried multiple expressions, but I am not familiar with it so I guess I am not using it correctly. Would you happen to know what the expression would be to get everything after the colon (:)?

Thank you.