BI Publisher (MOSC)

MOSC Banner

Question using Instr and substring

edited Sep 27, 2016 5:00AM in BI Publisher (MOSC) 5 commentsAnswered
I'm trying to parse out the fractional routing number into 2 separate fields so that I can change the format on a check.  The field stores the data with a '/' and my user wants it to display on the check as 2 separate fields.  Everything before the '/' as the stop number and everything after as the bottom number.

I've tried the following to parse it out:

<?xdofx:substring(Fractional_Routing__,1,xdofx:Instr(Fractional_Routing__,'/',1)-1)?>    --to get the top portion

and

<?xdoxslt:right(Fractional_Routing__,3)?>    --to get the bottom portion

This isn't working.  Any suggestions?

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