I have a 'Long Text' field, it came from a bundle so I can't really change how it's set up. In this long field (about 8500 characters) there is a substring called 'folio' that has a value, here's a snippet:
Moneda="USD" total="738.6" tipoDeComprobante="ingreso" folio="3" xsi:schemaLocation="htt
I need to find the value inside the quotes of 'folio', in this example I need to return the value '3', and put this in search results.The problem is that this substring is 1900 characters into the long text, and the SQL functions REGEXP_INSTR and INSTR can't find it, there is a limit around the 1000th character.Any ideas on how to pull this value?