I have a NAME column with values like XXX, YYY (LastName, FirstName). Can you please help me with report formula to show the values like YYY XXX (FirstName LastName)?
What did you try so far? Because if you tried, you definitely had it right after few attempts...
LOCATE tells you where the ',' is in your string, then you need to take what is on the left and on the right.
For the XXX part, if you use LEFT() it's easier, because you can use the result of LOCATE() -1 to get the number of characters to take.
For the YYY part you need to know how many characters you need to take. Here using RIGHT() will be easier, because you can use LENGTH() - LOCATE() -1 to get the number of characters.
If you did use SUBSTRING you could get the same result, but while for the XXX part it would be the same complexity than LEFT(), for the YYY part you would have an addition call to LOCATE() because you need to have the start position and the number of characters. By using RIGHT() you gain 1 call to LOCATE(), and that's always good because less functions = less work for the database.
By the way: when you have a question you should use "Ask a question" and not "New Discussion".
Thank you so much for the details
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Agenda Presentation: Optimize FDI Workbook Performance Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in mind from the start. As a special…
Join us as two of our top Oracle Analytics Cloud (OAC) expert practitioners, Carter Beaton (Argano) and Gautam Pisharam (Oracle), review and demonstrate the latest features of the July and September 2026 OAC releases. Analytics and Data Oracle User Community (andouc.org) is the premier global Oracle technology user…
