Field calculations for adding spaces between values

MatthewForsberg

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!

XanderBakker

If I use something like this (Python parser):

txt_in <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Curb spalling, 3ftx4ftx6ft'</SPAN>
txt_out <SPAN class="operator token">=</SPAN> txt_in<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'ft'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' ft'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">' x '</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> txt_in
<SPAN class="keyword token">print</SPAN> txt_out<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

this will yield:

Curb spalling, 3ftx4ftx6ft
Curb spalling, 3 ft x 4 ft x 6 ft<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

So probably try and use:

!YourFieldName!.replace('ft', ' ft').replace('x', ' x ')<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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