Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Extract Text that doesn't has a fixed length of characthers using Text/ Conditional F.

Summary:

Using EPM Management Report

I see this options for Mid Text Functions:

Left/Right/Mid


Left, Right, and Mid allow you to trim text from the results of other text functions such as MemberAlias and MemberName to keep only the left-most, right-most, or center text.


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.

These are my Aliases examples:

Company 123435325, LLC
Company 123435, LLC
Company 15325, LLC
Company 123435325000, LLC

And I need this:
123435325
123435
15325
123435325000

Maybe something like:
Mid(MemberAlias("Entity"),#, )


However, this only gives me the start position. I need a specific number of characters that stops at ", LLC," similar to a calculated variable. as the num of characters It will vary from alias to alias.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!