Is it a way using Regex to extract the string between a 2 occurrence of a character then replace it with another character. I know that's a bit tricky but i believe it's possible using Regex .. I just tried many ways but seem not working with me.
What i want to achieve is Extracting from this string:
TestNumQ_RY_5100001_OS35QWE_20190702-2.ZIP
The String between the First and Third _:
RY_5100001
Then Replace this _ with / so the end result will be:
RY/5100001
What i can reach until now is using this:
(_(.*?)_)([^_]*)
Which retrieve only the below string:
_RY_5100001
But i need it to be:
RY_5100001