Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
