OTBI - Locating 5th occurrence of character
Several fields have been migrated into one field and need to split into separate columns into OTBI
We need to pick the department from the code combination below.
For eg: if it is PTA01.1100001.0.101.240.6188.8.131.52.0.0 then I need to pick only 240 which is our department field which is after the 4th '.'
How can I achieve this in OTBI?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):