Categories
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