You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Need help from substr and instr function used in etext template

Received Response
21
Views
1
Comments

Summary:

Hello Team,

I need help from substr and instr function used in etext template.

For Ex; NAME (11001-Benefits Services)

in etext template, i used substr(NAME, 7, 100) - its display output as 'Benefits Services' - this is correct.

few of the departments, there is no value before number digits, for ex: NAME (Benefits Services) - s Services - this is not correct.

Expected value: Benefits Services

my question is only displaying the value after '-' its available digits befor or not.


Need help from substr and instr function used in etext template

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!