nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to remove spaces with Calculate field in ArcMap?

LianaSmith

My values are padded with spaces. Sometimes it's "1", sometimes it's " 1" sometimes its "1 ".

I need to remove all the spaces before, between, after, wherever they appear...

Thanks!!!!

Find more posts tagged with

Accepted answers

All comments

ChrisSmith7

For leading and trailing whitespace, I would recommend using Python String strip() Method

Here's an example:

For any and all spaces, try replace:

LianaSmith

Thanks, Chris. I need to use it in the Model. I am not familiar how I can add this to the model... Is there any way to do it with Field Calculator?

ChrisSmith7

Sure, here's an example in the model (for replace):

This tool is available under...

>> Data Management Tools

>> Fields

>> Calculate Field

LianaSmith

Chris, it works but I get zeros for some of the values..

For example, before I had "B", " B", "000B2"

After calculation I get: "B", "000B", "000B2"

I don't want it to be "000B"

For the rest of the records it worked fine

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.