Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 239 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Trim spaces from presentation variable
How do I trim spaces from a presentation variable, entered by user in a prompt? I know how to use the trim function, but not sure where to use the function. Is there a way to add this to the prompt itself, or would I trim in the filter?
Answers
-
I would use a SQL filter in the analysis like:
"Table"."Column" = TRIM(BOTH ' ' FROM '@{Variable}')
0 -
Federico told you where to use it...
For your question about "is there a way to add this to the prompt itself" it depends ...
Do your users write the value of the variable in a text field? If yes you can't really do anything there .... If the users enter the values by selecting in a drop down list you can of course trim the values in the list (but why not trim them in your DB directly?)
0 -
That works great. Thanks very much, Federico.
0 -
Yes, it's a text field they are using for input. I do not have access to write to the database directly. Fortunately, considering my current level of skill
0
