topic Re: How to remove comma separator in Experience Builder table in ArcGIS Experience Builder Questions

How to remove comma separator in Experience Builder table

CalebAnderson — Wed, 13 Jul 2022 22:31:07 GMT

Hello! I'd like to remove the thousands comma separator in the table I have in an experience:

I tried going to the visualization for the feature and unchecking the thousands separator. Also tried pulling the data from a web map where I did the same with no luck:

Re: How to remove comma separator in Experience Builder table

jcarlson — Thu, 14 Jul 2022 01:33:14 GMT

What version of EB are you using? And is your datasource being referenced by the table directly, or is it a view? In older versions of EB, data source views would ignore field-level formatting options of the original data source.

Re: How to remove comma separator in Experience Builder table

TianWen — Fri, 15 Jul 2022 06:20:53 GMT

This is actually what we are implementing recently and the table will be able to honor the thousand separator (and other settings) soon.

Re: How to remove comma separator in Experience Builder table

CalebAnderson — Fri, 15 Jul 2022 17:53:00 GMT

Thanks @TianWen, looking forward to it

Re: How to remove comma separator in Experience Builder table

JoshTownsend — Wed, 01 Feb 2023 09:45:13 GMT

@TianWen can you provide an update on this enhancement? Thousand seperators are still showing in enterprise Experience Builder 10.9.1 atleast.

Re: How to remove comma separator in Experience Builder table

d-slet — Mon, 20 Feb 2023 21:14:54 GMT

I'm utilizing Enterprise Builder in AGOL and we still are experiencing this issue. I tell you this because Enterprise releases generally follow AGOL and it has yet to have been implemented in AGOL. Maybe and ESRI rep can chime in but I have not found a resolution to this issue.

Take care.

Re: How to remove comma separator in Experience Builder table

AW_Grove — Wed, 05 Apr 2023 19:04:44 GMT

I'm still seeing this issue too.

Re: How to remove comma separator in Experience Builder table

CristianGraf — Wed, 26 Apr 2023 22:18:51 GMT

Have something similar... with a bonus problem!

When exporting a CSV on the export tool, we have some issues on the CSV. As some people are entering commas (,), well colums and lines are a total mess on Excel.

Any ideas how to change the separator on ExBuilder? On the REST?

Thank you! for any help or work around!!!

Re: How to remove comma separator in Experience Builder table

AaronKoelker — Thu, 08 Jun 2023 16:15:30 GMT

Still seeing this issue. I'm assuming the planned fix never made it?

Re: How to remove comma separator in Experience Builder table

BrianEaster — Wed, 27 Sep 2023 13:02:05 GMT

It seems that as of 27 September 2023 the table still is not honoring the settings of the layer in the attribute table widget. I was searching for a solution and found this.

The pop ups are and map widgets in Experience Builder all honor the settings properly. Only the attribute table has a thousand separator and the time in a date field showing.

Re: How to remove comma separator in Experience Builder table

Adam_Bourque — Thu, 28 Sep 2023 13:54:21 GMT

Agreed, this is still unfortunately the case. It is disappointing as we want to use experience builder for replacement of web app builder yet this seems to be the one major hold out as it is a pain to have to format every time for exports which is main purpose of web app / experience builder.

Re: How to remove comma separator in Experience Builder table

KaraUtter2 — Fri, 13 Oct 2023 19:10:32 GMT

Here we are in October 2023 and we still have this issue. I have formatted the number values in both the web map and visualization tab of the feature layer itself and still the table widget will not honor the formatting for anything, including Dates, Integers, Doubles, etc. This is very frustrating.

Re: How to remove comma separator in Experience Builder table

ShefaliVerma_afsc — Tue, 31 Oct 2023 00:06:09 GMT

I still can't format the fields in the Table widget.

Re: How to remove comma separator in Experience Builder table

VenkataSrikanthDasari — Fri, 03 Nov 2023 04:41:26 GMT

Hello GIS Developers,

@KaraUtter2 @BrianEaster @Adam_Bourque @CalebAnderson @jcarlson @TianWen @ShefaliVerma_afsc @JoshTownsend @d-slet @AW_Grove @CristianGraf @AaronKoelker

After spending one long week I try to understand the API code and figured out a solution.. Esri didn't implement the field formatting but we can implement using a small code modification.

1. Download the JavaScript API from this link and ArcGIS Javascript API and host the API in your web server (I placed ArcGIS JavaScript API beside to the actual application)

2. Navigate to 4.23 --> Esri --> widgets --> FeatureTable --> FieldColumn.js file and search for the below line of code and usually it exists in the declarations section (line 7 in 4.23)

M=A.convertNumberFormatToIntlOptions({digitSeparator:!0,places:null})

3. Just replace !0 with 0 and that's it. It worked for me like a charm.

M=A.convertNumberFormatToIntlOptions({digitSeparator:0,places:null})

4. Now I don't see comma in Integer, Float and Decimal datatype columns.

Note: Use this URL https://js.arcgis.com/4.23/ locally while building the custom widgets in the client folder. Replace the URL https://js.arcgis.com/4.23/ with JS API deployed URL https://domainname.com/4.23 in the client folder in all the files. Build the package and deploy it.

Happy and Enjoy coding 😎

- Srikanth Dasari

https://www.linkedin.com/in/srikanth-dasari-0526/

Re: How to remove comma separator in Experience Builder table

SerjStol — Fri, 03 Nov 2023 12:18:12 GMT

I can confirm this setting is still NOT honored in ExB within AGOL after the latest October release. The thousands separator option toggle works fine in the Attribute Table within Map Viewer, but does not affect Table Widget in the Experience Builder.

Re: How to remove comma separator in Experience Builder table

VenkataSrikanthDasari — Thu, 17 Oct 2024 23:42:26 GMT

Here is the screenshot for the Experience Builder - Table widget uses ArcGIS Portal. @SerjStol

Re: How to remove comma separator in Experience Builder table

SerjStol — Fri, 03 Nov 2023 15:40:24 GMT

Thanks, your code change looks like a neat way to fix this in an ExB Developer Edition, however, we are using ArcGIS Online built in Experience Builder so its not possible to make a code change and we are not switching to Dev Edition any time soon.

Re: How to remove comma separator in Experience Builder table

RobertAnderson3 — Mon, 11 Dec 2023 19:37:29 GMT

Any updates on this @TianWen ?

Re: How to remove comma separator in Experience Builder table

Andrus_Nicholas — Thu, 29 Feb 2024 15:43:32 GMT

Issue appears to persist through February 2024 update.

Re: How to remove comma separator in Experience Builder table

CherieBryant — Tue, 28 May 2024 21:28:52 GMT

The text widget also does not honor the MapView number formatting.