Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

split string into columns using comma

TKQ5QJan 10 2022

I have a string that contain the saleperson staff ID and their name.
I am trying to split it into 2 column like in excel.
1 column for staffID and 1 column for Name.
z32596, DanielS
z85698, BrownST
z58965, TanYUN
I tried using the string formula from out of the box, but do not know which one to use.
Can someone advise. Thank you.
I am using I am using Oracle Business Intelligence Enterprise Edition 11.1.1.7.

This post has been answered by Gianni Ceresa on Jan 10 2022

Jump to Answer

Added on Jan 10 2022

#analytics, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #excel

3 comments

849 views

1 mention