idea how to remove last 3 commas data in ArcGIS Online Ideas

how to remove last 3 commas data

KarraRAJENDAR — Fri, 19 May 2023 13:41:15 GMT

Field_Name

a,b,c

w,f,b,j

g,y,x,o

I,o

p,p,r,c,g,k

p,p,r,c

in above table i want remove data after 2 comma. can any pls suggest.

KenBuja — Fri, 19 May 2023 14:10:30 GMT

You can do this in Arcade

var arr = Split($feature.Field_Name, ',') if (Count(arr) < 3) return $feature.Field_Name; return Concatenate([arr[0], arr[1], arr[2]], ',');

KarraRAJENDAR — Fri, 19 May 2023 15:34:43 GMT

@KenBuja can u please give for calculation in arcmap

KenBuja — Fri, 19 May 2023 16:37:58 GMT

You should mention what you're working in when posting a question.

This Python script will do what you want

def Calc(field): arr = field.split(",") if (len(arr) < 3): return field else: return ",".join(arr)