I have two JSON inputs that I would like to join together one of them is the routers. It has a URL that links to the Last Known Location.
The Last Known Location id from the routers Json is used to find the lat/long from the locations Json.
The ID in the locations json is simply the string without the URL
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
EVALUABLE_EVALUATION_FAILED_CAUSE
replace(replace(last_known_location,'https://www.mysite.com/locations/',''),'/','')
Thanks Mele
