https://community.esri.com/t5/arcgis-geoevent-server-questions/error-when-using-replace/m-p/1168446#M3771 <P>I have two JSON inputs that I would like to join together one of them is the routers.&nbsp; &nbsp;It has a URL that links to the Last Known Location.&nbsp; &nbsp;</P><P>The Last Known Location id from the routers Json is used to find the lat/long from the locations Json.</P><P>The ID in the locations json is simply the string without the URL</P><P>I am trying to use the field calculator processor to replace the URL in a field called last_known_location and return just the ID but am getting this error</P><P><SPAN>EVALUABLE_EVALUATION_FAILED_CAUSE</SPAN></P><P>replace(replace(last_known_location,'<A href="https://www.mysite.com/locations/',''),'/" target="_blank">https://www.mysite.com/locations/',''),'/</A>','')</P><P>Thanks Mele</P> Wed, 27 Apr 2022 17:03:53 GMT MeleKoneya 2022-04-27T17:03:53Z https://community.esri.com/t5/arcgis-geoevent-server-questions/error-when-using-replace/m-p/1168446#M3771 <P>I have two JSON inputs that I would like to join together one of them is the routers.&nbsp; &nbsp;It has a URL that links to the Last Known Location.&nbsp; &nbsp;</P><P>The Last Known Location id from the routers Json is used to find the lat/long from the locations Json.</P><P>The ID in the locations json is simply the string without the URL</P><P>I am trying to use the field calculator processor to replace the URL in a field called last_known_location and return just the ID but am getting this error</P><P><SPAN>EVALUABLE_EVALUATION_FAILED_CAUSE</SPAN></P><P>replace(replace(last_known_location,'<A href="https://www.mysite.com/locations/',''),'/" target="_blank">https://www.mysite.com/locations/',''),'/</A>','')</P><P>Thanks Mele</P> Wed, 27 Apr 2022 17:03:53 GMT https://community.esri.com/t5/arcgis-geoevent-server-questions/error-when-using-replace/m-p/1168446#M3771 MeleKoneya 2022-04-27T17:03:53Z