Online Tutorials & Training Materials |
Register Login

BI Publisher: Instr and Substring

|| || 0

BI Publisher: Instr and Substring

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:

--to get the top portion


--to get the bottom portion

This isn't working. Any suggestions?