This is the string: "WATERMARK('Hello!')"
What I want to extract is "Hello!", excluding the "WATERMARK" and the brackets ('Hello!', can be anything so I need to extract the text from here, and for the last I need to replace WATERMARK('') with nothing in the original string)
How can I do this?