Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response

32

Views

1

Comments

eransom

eransom Rank 1 - Community Starter

Jul 3, 2025 4:33PM in Oracle Fusion HCM Analytics

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

Tagged:

FDI

0

Answers

Bhaskar Konar Rank 8 - Analytics Strategist

Jul 3, 2025 7:53PM

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.

0