Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 45 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 284 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 109 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Presentation variable and left function
48d95e02-1a68-4e67-acad-79e66af6b059
Rank 1 - Community Starter
Hello to all,
How can I run a string function like "left" to extract only a few large ones from a slash-by-slice presentation?
For example, I wrote the following:
"FL_L_IN_SAP". "PARTITION_KEY" IN ('ERP _ @ {LEFT (PartitionEntity, 6)} ....
But without success.
Thanks a lot to everyone,
Livio
0
Answers
-
Please provide an example , so that people will understand better.
0 -
You need to use the substring function, in conjunction with the locate function, see below for a very similar question =>
0 -
Hi,
on your slice by slice the only other point is to move your generated value to a page or prompt level.
Do you still have an issue?
0