I have a list with employee names all in upper case. E.g. DANIEL SMITH
How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
Hi @RebeccaL - you'd need to use a combination of Left, Right, etc to get the desired result. There is this very old idea about having Proper() as a function within the platform.
Thank you, I think the function of Proper would be really helpful in Anaplan. Calculations can be used to get around this when it is a simple case of first and last name. I have some employee names where they have 2 middles name so it gets a bit complicated.
Hey , you can use lower(name(item)) to convert it to lower case
@Kanishq17 I guess he needs it to be in initial case, where you capitalize the first letter of every word. At present I don't think so we have any functions like that, we have UPPER, LOWER, LEFT, RIGHT functions to do the transformations.
Daniel Smith - upper case on the first letter then lower case for the remaining we don't have any function for such conversion in Anaplan currently.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
