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

Remove spl char from the phone number

edited Dec 13, 2022 6:46AM in Taleo Enterprise 4 comments

Hi Experts,

I've the below script for which i need to eliminate special characters like(_.-,&,$ etc) in the number.

I tried adding "REGEXP_REPLACE" but it is saying "NOT Valid".

Please let me know if this can be sorted out.

<quer:substring>

  <quer:replaceNullOrNot>

   <quer:field path="Candidate,HomePhone"/>

   <quer:field path="Candidate,HomePhone"/>

   <quer:replaceNullOrNot>

    <quer:field path="Candidate,WorkPhone"/>

    <quer:field path="Candidate,WorkPhone"/>

    <quer:replaceNullOrNot>

     <quer:field path="Candidate,MobilePhone"/>

     <quer:field path="Candidate,MobilePhone"/>

     <quer:replaceNullOrNot>

      <quer:field path="Candidate,PagerPhone"/>

      <quer:field path="Candidate,PagerPhone"/>

      <quer:string/>

     </quer:replaceNullOrNot>

    </quer:replaceNullOrNot>

   </quer:replaceNullOrNot>

  </quer:replaceNullOrNot>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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