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
Comments
-
Have you tried the function Substitute?
https://help.anaplan.com/841babeb-4694-4761-91c1-18d920edb879-SUBSTITUTE
2 -
Now that's something new learnt today.
0 -
Well Substitute function won't work as it is a series of projects and we have to remove the 3rd character specifically if 0
0 -
I am trying IF ELSE condition with LEFT/RIGHT function to spot the 3rd character
0 -
Could you use find and if that returns 1 you've got your logic check. Then you could do the removal?
0 -
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
0
