Python script to remove spaces in notebook

Question

I'm having real trouble with getting a script to run in notebook to simply remove spaces from a field.

item=gis.content.get('528e3960da004561999c50dcaa52a781')
l=item.layers[0]

print(l.calculate(where="OBJECTID > 0",
calc_expression={"field": "test2", "sqlExpression": "Replace(test2," ","")"}))

This fails and upon further investigation the REPLACE SQL function is not supported. So I need a python script to run and remove spaces in a hosted feature layer's field. The reason why is a long story but this has to be running at least every 30 minutes 24/7, for the extent of COVID..  The field I am trying to remove spaces from is called test2. If I can get something to work then ill use the code on the actual feature layer.

I pretty much have no idea what I am doing with notebook.

failed script.JPG

Untitled.png

BernSzukalski_3-1712765624290.png

JonathanWhite1 · Answer

I have to automate it in AGOL so as far as I know the only way would be through using notebook? This is the first time I have used python at all. Yea I think I am in over my head but do not have much of a choice due to some things not being supported in Survey 123. The code you provided is starting to make sense as far as how things are being defined and later called. I am thinking that arcpy might already be in the AGOL notebook so perhaps it doesn't need to be imported or called at all. Thanks for your help. I will just keep trying stuff until something serious breaks.

DavidPike · Answer

Do you have to do it in the notebook? Can you import arcpy in the notebook (I'm not really conversant in the notebook interface)?

Outside a notebook I gues you would need

from arcgis.gis import GIS

import arcpy

'yea' isn't a great reply to someone who spent time to assist you.

JonathanWhite1 · Answer

Yea its saying arcpy is not defined.