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