Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Display only last 4 digits of National Identifier
OBIEE - Would someone please help with a formula to display only the last 4 digits from this social security number field? The field name is "Worker"."Primary National Identifier Number"
Example: change 123-45-6789 to 6789. Thanks!
Answers
-
SUBSTRING("Worker"."Primary National Identifier Number" FROM LENGTH("Worker"."Primary National Identifier Number")-3 FOR 4)
0 -
Thank you so much for your quick response. You made my day!
0 -
Simpler and shorter: RIGHT("Worker"."Primary National Identifier Number", 4)
When you click on the "f(...)" button in the formula editor you can easily see available functions (in categories, with a short description of the function and parameters).
0 -
+1 to Gianni's solution. Why use two nested functions that have to be parsed for every single record if RIGHT does the same job.
0
