Adding spaces in string using Python parser of ArcMap field calculator

Question

I am using ArcGIS Desktop 10.6.

I have a integer field [no_lot] which contains values in the following format: '3 546 777' I need to transfer the data into a text field for joining purposes.

I created a text field named [lot_text]. I ran the field calculator for the field [lot_text] with the following expression:

[lot_text]=[no_lot]

which returned values in this format '3546777', so the space thousand separators have been removed.

How can I calculate the field while keeping the thousand separators using Python or else?

Answer 1

As stated in the comments. There are two potential ways to preserve the thousands separator using the field calculator:

Using the Python Parser in the Field calculator:

format(!no_lot!, ",").replace(","," ")

or as per @PolyGeo's suggestion:

"{:,}".format(!no_lot!).replace(","," ")