Removing '0' from 3rd place

ankulkarni

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 

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