topic Re: Field calculations for adding spaces between values in Business Questions

Field calculations for adding spaces between values

MatthewForsberg — Fri, 04 May 2018 19:47:03 GMT

I need to clean up some attribute tables and I'm having some difficulty finding a way to fix a certain issue. I have columns that have strings such as "Curb spalling, 3ftx4ftx6ft," and want to add spaces. I want it to look like this; "Curb spalling, 3 ft x 4 ft x 6 ft." I'm not very good with editing attributes in this manner so I was wondering what I could do, rather than having to do every single row of the column manually..Thanks!

Re: Field calculations for adding spaces between values

DarrenWiens2 — Fri, 04 May 2018 22:21:26 GMT

You can replace text in tables. I'd start by replacing "ftx" with " ft x ", and then tackle the other edge cases.

How To: Replace the text in multiple fields within an attribute table using the Find and Replace tool

Re: Field calculations for adding spaces between values

MatthewForsberg — Wed, 09 May 2018 11:56:37 GMT

That's about the only thing I could figure out, haha. The other part of my question is actually the issue!

Thank you though!!!

Re: Field calculations for adding spaces between values

XanderBakker — Sun, 12 Dec 2021 01:17:11 GMT

If I use something like this (Python parser):

txt_in = 'Curb spalling, 3ftx4ftx6ft'
txt_out = txt_in.replace('ft', ' ft').replace('x', ' x ')

print txt_in
print txt_out‍‍‍‍‍

this will yield:

Curb spalling, 3ftx4ftx6ft
Curb spalling, 3 ft x 4 ft x 6 ft‍‍

So probably try and use:

!YourFieldName!.replace('ft', ' ft').replace('x', ' x ')‍

Test this, writing to a new field, rather than replacing the existing values.