Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

RDA LTRIM([RV String],'AZ-') returning weird results

edited Apr 25, 2017 9:49AM in Design Tools & Output Technologies - JDE1 (MOSC) 2 commentsAnswered

hi all,

I am using the text function LTRIM to remove the first three characters from a string.  When I use LTRIM([RV String], 'AZ-') from a string AZ-123456 it is returning Z-1234.  The expected result should be 123456.   I removed all blanks from the string, and tested the length as well.  Can you advise what needs to be done to retrieve the expected result?

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center