How to Add a Count of the Number of Missing Values in each Row of Data

[setzer715]

Hi,  I'm trying to add a zero to the middle of a string.  For example, I have A3A021 and I'm trying to make it A3A0021.  Any help would be appreciated!

[Dynamomo · Accepted solution]

@setzer715

I feel like I need to understand the business logic better to answer this but if the expectation is that there will always be six characters coming in, and you need to add the zero in the middle of them them, then using a formula tool, you can simply create a new field and enter left([Field],3)+"0"+right([Field],3)

This takes the first three characters starting from the left, adds a zero and then concatenates with the first three characters starting from the right side.

If the logic is something else, please specify.

[setzer715]

Thank you, what you posted worked fine.  Yes, the list of ID's will always be 6 characters.