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

Extract Substring (of varying length) within a String (of varying length)

Accepted answer
51
Views
6
Comments
edited Dec 12, 2017 11:26PM in Reporting and Analytics Taleo Enterprise 6 comments

Summary

How to extract a sub string from within a string

Content

Hi There, I have a situation where I have a text string of the format. To be precise it is the Grade Code in Fusion HCM. XXXX-NNN-YYYY All of X, N and Y can be of varying lengths. The only distinguishing character I can use is '-' Is there anyway I can extract the NNNs between the two dashes ('-')? Thanks, SS 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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