</ Hi , I have a column where I have a string like below. This is inside a column.
ABCC_123%XYZ_123%PQR_99%MNP_89
If you see we have a delimiter to split using % and get the value. One more condition is , we have to split with delimiter as (%) and the last characters should not be _123 and if it found we have to ignore and then again check for _123 .So in this example we can see the 3rd value does not have the _123 and we can extract that. How can we do in a Query.
My result should be PQR_99