Removing '0' from 3rd place

Options
ankulkarni
ankulkarni Member, ALL USERS, Community Member Posts: 5 Contributor
in Planning & Modeling

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 

Tagged:

Comments

  • ankulkarni
    ankulkarni Member, ALL USERS, Community Member Posts: 5 Contributor

    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
    ankulkarni Member, ALL USERS, Community Member Posts: 5 Contributor

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

  • smaddi
    smaddi Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    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

Categories