How do I get the characters before a specific character?

zdlee_*66937

Let's say I have column username where the drop down is a list. A username is "JonSmith-81". I'd like the next line item, lets call it alias, to just pull "JonSmith" from this string. The alias line item is formatted as text. What would be the formula to return just "JonSmith" in alias line item? I seem to get an error due to the mismatch in formatting.

rob_marshall

@zdlee 

 

I believe we answered this in your previous post on Friday...

 

https://community.anaplan.com/t5/Anaplan-Platform/How-do-I-get-the-characters-before-a-specific-character/m-p/129113#M32845

 

Rob

zdlee_*66937

Hi @rob_marshall,

 

I forgot to mention the formats of the field and the solution provided didn't work due to the formats, as so it seems.

rob_marshall

@zdlee 

 

Then use the name() function around the User Name which is list formatted.