Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Trim trailing the keywords
Summary
Having trouble extracting a portion of job descriptionsContent
Experts ~
I am having trouble removing the last section of our job descriptions starting with the keyword "Comment". The goal is to capture the minimum requirement of each job and export it for further analysis. It shows an error message after I added the "Trim Trailing" syntax. I wanted to get rid of the sentences that are "can messages" for applicants with questions. Could you please tell me how to do it correctly ? Thank you so much.
TRIM(TRAILING 'comment' FROM lower(concat(CONCAT("Requisition Identification"."Qualifications (External) (1st Part) (BL)", "Requisition Identification"."Qualifications (External) (2nd Part) (BL)"),"Requisition Identification"."Qualifications (External) (3rd Part) (BL)")))
Tagged:
1