Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 185 Oracle Analytics News
- 40 Oracle Analytics Videos
- 15.3K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Management Report - MID Function

User_TLZGJ
Rank 1 - Community Starter
Hi All,
I'd like to know how can I achive a result using mid function in Management Report: Current Syxtax:
Syntax
Left (
text
,
[number_of_characters]
)
Right (
text
,
[number_of_characters]
)
Mid (
text
,
start_position
,
[number_of_characters]
)
Note:
"number_of_characters" is optional for the Mid
function.
Although what I need is to extract the middle of an alias
Entity Alias below (Example) :
Company 123435325, LLC |
---|
Company 123435, LLC |
Company 15325, LLC |
Company 123435325000, LLC |
Expect Result:
|
0