Regarding OSA Conditions
(Doc ID 2804874.1)
Last updated on MAY 16, 2023
Applies to:
Oracle Stream Analytics - Version 19.1.0.0.1 and laterInformation in this document applies to any platform.
Goal
New requirement from Business is that have to remove leading 0's from String in OSA.
Customer have tried multiple things:
1. Tried to convert string into int, its not possible as value may contains characters as well.
2. Unable to implement this - trim(TO_CHAR(trim(LEADING 0 FROM a.POS_ID))) its working in oracle db
3. Tried replacing string with "^0+" this regex. replace(terminalId,"^0+","")- its not working giving same result as 0013445
Need help on this.
OSA Version - 19.1.0.0.0
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |