BI Publisher (MOSC)

MOSC Banner

substr and instr in RTF

edited Aug 4, 2020 8:38AM in BI Publisher (MOSC) 11 commentsAnswered ✓

Hi,

I have a data field in my xml called GRE. In the .rtf, I can display this with <?GRE?>

The value in GRE is Company Name (XYZ) and I need to hide the (XYZ) portion.

I tried using this: <?substring(GRE,1,instr(GRE,'(',1)-2)?>

But, it did not work. This is for payroll checks, and no File Reporter is being output. Do you have any substr/instr examples that have worked?

Thanks,

Ellen

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