I couldn’t find this anywhere in the community so now that I have it I thought I would share.
I have a path like this file:///eloqua/test/test.json
I want it like this file:///eloqua/test (no file name in the path)
It looks like this in a mapper
Hope this makes someone else’s journey a bit less painful.