Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI - Locating 5th occurrence of character using substring and locate
Summary
Several fields have been migrated into one field and need to split into separate columns into OTBIContent
Several fields have been migrated across as one field separated by a "."
I am trying to pick up the 5th occurrence of "." in the below field and not display any data after this field.
For example in the below example I need to extract "09"
PTFA..UNIDAYS.01.Yes.09.2021.Admin.No.
The below picks up everything from the 5th full stop (period) onwards, but I just want to display the two digits.
This field is also not always populated so could end up being empty.
Tagged:
0