Removing '0' from 3rd place

I want to create a new filed and a logic where the input will be project name which is a combination of letter and and digits. The new input field should replace '0' in the 3rd place of the project.

E.g- PROJECT NAME: PR120 then new calculation field should remove '0' in the 3rd place

what can be the syntax to remove or not consider 3rd digit if '0'

Thanks

Ankur Kulkarni

Accepted answers

All comments

rob_marshall

@ankulkarni

Have you tried the function Substitute?

https://help.anaplan.com/841babeb-4694-4761-91c1-18d920edb879-SUBSTITUTE

andrewtye

Now that's something new learnt today.

ankulkarni

Well Substitute function won't work as it is a series of projects and we have to remove the 3rd character specifically if 0

ankulkarni

I am trying IF ELSE condition with LEFT/RIGHT function to spot the 3rd character

andrewtye

Could you use find and if that returns 1 you've got your logic check. Then you could do the removal?

smaddi

Hi ankur,

The lineitem that has the proj name, create a new line item and use FIND("0",Proj Name lineitem). This will tell where 0 is in the name. Based on your req you can then say, if new line item = 3 then "whatever you need to replace with" else Proj Name

Hope this helps...

Sunil.Maddi

Quick Links

Can you help?

Unanswered questions

Hide the cards under "Models" section once connected
Hi Is there a way to hide the cards under the "Models" section once connected, as I would like the users to see only the links to the apps? Thank you
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
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.…