Online Tutorials & Training Materials | STechies.com
Register Login

BI Publisher: Instr and Substring

|| || 0

BI Publisher: Instr and Substring
Stechies

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

and

--to get the bottom portion

This isn't working. Any suggestions?


Related Articles