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!!!!

Vind meer berichten getagd met

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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