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; } } }

Add Space Between Combined Fields in Field Calculator

JRAdams

In the ArcGIS Online field calculator I am trying to combine a few other fields into one (address field) and cannot figure out how to put a space between the fields. I am sure it is something simple, but I am unable to find the answer elsewhere. Please help! I've tried everything I can think of.

Thank you!!! AGOL Admin fieldcalculator #arcgisonline

Find more posts tagged with

Accepted answers

KellyGerrow

Two methods of concatenating 3 variables with a space in this post. I'm going to summarize both methods so the solution is clear. For this example feel free to use the layer mentioned below. I have left it editable, so that you can test out the differences of the two methods . Using Arcade is the most straight forward and flexible depending on how you plan to use the created field.

Example Web Map and layer

https://www.arcgis.com/home/webmap/viewer.html?webmap=1267db066ab144e086f84801f5022ef6

Create an Arcade expression for displaying in pop ups (or labels or symbology). Arcade can be used to display formatted data as a new field in pop ups or for symbology. If you are using Arcade, any updates to existing data will be displayed in the expression as the expression is created at the time of the pop up to display up to date values.

Steps:

1. Add layer to Web Map: https://www.arcgis.com/home/item.html?id=7810a6a9ccd0406fb3b7ce7f10aac818

2. Configure Pop Up > Add Attribute Expression

3. Add Expression: Concatenate([$feature.dog1,$feature.dog2,$feature.dog3], ' ')

4. Ensure the created expression is checked to display in pop up (all dogs in this example)

Note: If you want to use this expression as a label or for symbolization, Click New Expression and then select the existing expression to use in web map

Calculate a field value in a table. You can calculate a concatenated field using the calculate field to. This is great for one time changes to data sets. The data will be updated at the time of the calculation and then may need to be updated manually or by calculation if the contributing fields were to change.

Steps:

1. Display data table in Map Viewer or on Data tab of item details page.

2. Add a field to the table (Calculated Field)

3. Ensure the Field is displaying in the table and select calculate

4. Enter the following calculation:

CONCAT(dog1,CONCAT(' ', CONCAT(dog2,CONCAT(' ',dog3 ))))

5. Verify that the calculated field displays correctly.

All comments

TanyaWinemiller

Yes! This worked perfectly. Thank you!

MikeMinamiP1

Adding HTML is a bit of a pain. Whenever I go back in to edit the popup it changes back to just text and then wipes any custom HTML.

You have to click the HTML view option to view the HTML. That being said, I found that the paragraph style with padding persisted in HTML view whereas the & nbsp; would disappear.

dougbrowning

Oh I was doing it in the return statement. That is where I use my \n. I do this so that I have a return of '' it does not leave a blank like for no reason.

Adding HTML is a bit of a pain. Whenever I go back in to edit the popup it changes back to just text and then wipes any custom HTML.

Thanks

MikeMinamiP1

I was able to make the two suggestions above work in HTML view (highlighted yellow below) of a custom popup, outside of the arcade expression. The paragraph padding method worked better, as the non breaking spaces were converted to spaces the next time I edited the popup configuration.

Mike

dougbrowning

How can I do leading spaces? It keeps striping them out when using Arcade in a Pop up.

This

return "\n" + " Line Number Issue! Found: " + txt

Does this - notice no spaces - I want to indent it.

Ideas?

Thanks

JoeBorgione

Dan- if a a feature service is hosted on AGOL, you are limited to playing by the AGOL rules. I've done python calculations (my preference; your influence) in ArcGIS Pro on feature services hosted on our own portal....

Dan Patterson‌

DanPatterson_Retired

Is field calculation in AGOL restricted to Arcade?

Then is the best suggestion is to do the 'work' of field concatenation in ArcGIS PRO or ArcMap? (where you have options, like superior Python )

JoeBorgione

Vote early and vote often! https://community.esri.com/ideas/14979

Kelly Gerrow‌

KellyGerrow

Hey Joe,

If using the calculate option in ArcGIS Online, you need to apply a specific filter in order to only calculate specific fields. Can you log an idea about calculating fields based on table selection on ArcGIS Ideas‌. I think this would be helpful to others also:

Work with fields—ArcGIS Online Help | ArcGIS

-Kelly

JoeBorgione

I got that to work in the data tab view. But, I can't seem to apply a calculation to a selected field in AGOL. Everytime I use the calculator it is applied to all fields, not just the selected one....

(first row selected, right?

results with all fields now valued with 'joe'

KellyGerrow

Example Web Map and layer

https://www.arcgis.com/home/webmap/viewer.html?webmap=1267db066ab144e086f84801f5022ef6

Steps:

1. Add layer to Web Map: https://www.arcgis.com/home/item.html?id=7810a6a9ccd0406fb3b7ce7f10aac818

2. Configure Pop Up > Add Attribute Expression

3. Add Expression: Concatenate([$feature.dog1,$feature.dog2,$feature.dog3], ' ')

4. Ensure the created expression is checked to display in pop up (all dogs in this example)

Note: If you want to use this expression as a label or for symbolization, Click New Expression and then select the existing expression to use in web map

Steps:

1. Display data table in Map Viewer or on Data tab of item details page.

2. Add a field to the table (Calculated Field)

3. Ensure the Field is displaying in the table and select calculate

4. Enter the following calculation:

CONCAT(dog1,CONCAT(' ', CONCAT(dog2,CONCAT(' ',dog3 ))))

5. Verify that the calculated field displays correctly.

JoeBorgione

I was able to use Arcade on my test hosted feature with ArcGIS Pro. (Seems kind of lame that you can't do it right there in the AGOL calculator....)

$feature.STREAM+' '+$feature.STREAM+' '+$feature.STREAM

returned the value of the STREAM field with a space between each one....

My guess is you can do the same thing with address components like this:

$feature.HouseNumber+' '+$feature.StreetName+' '+$feature.City+' '+$feature.Zip

(whatever your field names are....)

JRAdams

I was trying to run as a field calc. Doesn't the Arcade only work on labeling or pop-ups (maybe symbology too?)

JRAdams

Nope, that one doesn't work in AGOL. Thanks though!

JoeBorgione

Rats- doesn't work for me. Sill getting the Unsafe sql expression not allowed....

Concatenate([$feature.STREAM,$feature.SITEID],' ')

Just two fields with CONCAT seems okay:

CONCAT(STREAM,SITEID)

I must be missing something here.....

KellyGerrow

Hi Joe,

Ensure that your fields are referring to features in your to your feature data and that you use the full Concatenate when referring to the function.

Check out the quick example in this web map:

https://www.arcgis.com/home/webmap/viewer.html?webmap=1267db066ab144e086f84801f5022ef6

The All Dogs field was calculated using the following expression:

Concatenate([$feature.dog1,$feature.dog2,$feature.dog3], ' ')

-Kelly

JoeBorgione

I've been trying to figure this one out with a concatenate but no luck:

CONCAT([Field1,Field2,Field3],' ')

Throws an error of 'Unsafe sql expression is not allowed'

This is from the online help as an example:

Concatenate(['red', 'blue', 'green'], '/')

Which is what I used to fashion my expression, but it fails with the same error.

Seems like adding a white space shouldn't need to be so difficult....

KellyGerrow

Do you need to perform this with field calculator and store this within a field, or would creating an expression using Arcade get you up and running?

Text Functions | ArcGIS for Developers

Use Arcade Expressions to Map Your Ideas

https://www.esri.com/arcgis-blog/products/js-api-arcgis/uncategorized/using-arcade-expressions-in-web-apps/

-Kelly

JimmyKroon

I haven't used the AGOL field calculator, but can you include a space in quotes in the calculation?

{field1} + " " + {field2}

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.