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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

TCC Projection Function to find Position of Character

edited Jul 31, 2019 1:13PM in Taleo Enterprise 2 comments

Summary

In an Export Projection, how can I find the position of a character in a string?

Content

In a TCC Export Projection, how do I find the position of a character in a string?  I'd like to use that value in Substring.

Example:

ExField: "Foo Bar (Hello) World"

Expected Results: "Foo Bar World"

<substring>
<field path="ExField"/>
<integer>
<instr path="ExField">
<string>(</string>
</instr>
</integer>
<integer>
<instr path="ExField">
<string>)</string>
</instr>
</integer>
</substring>

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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