How do create a calculation to remove hyphens and preceding string data or split into 2 columns?

Question

Is there an efficient way to split department number from department name?

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26398/how-do-create-a-calculation-to-remove-hyphens-and-preceding-string-data-or-split-into-2-columns

Hi @eransom,

Welcome to the Oracle Analytics Community!

Please try using the function like 'Substring'; here is a good document which might be useful for the understanding.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/functions.html#GUID-BBA975C7-B2C5-4C94-A007-28775680F6A5

Hope this help.

Thank you.