How to Add a Count of the Number of Missing Values in each Row of Data
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, what you posted worked fine. Yes, the list of ID's will always be 6 characters.