REPLACE() in Spreadsheet Node

[saica]

I am attempting to basically Find/Replace some values in an entire spreadsheet, but I cannot seem to get it to function as I hoped, at all.

Any advice that could be given for the below screenshot? (might need to open the image in a new tab)

Thank you.

[Niklas_Hatje]

Hey Saica. It seems like you’re not getting the right key in the screenshot, do you? I would expect the expression to look like this:

{{ $json["EC Next Avail"].replace("AVAIL: ", "") }}

like in my example below:

Hope that helps. Try to drag and drop the data in the input next time, that makes your live so much easier

[saica]

Ah, was missing the quotes around the field name. Appreciate the second set of eyes.