Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
String Length Limit in SQL... How can I work Around?
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.
0