Replace based on logic

[Anonymous]

Sorry I cannot reply to the other thread as it says, new user can only reply 3 times in a thread.

So answer to your question

@Johnnycash

Okay, I don’t want to use the column position, so the simple answer here is that I have rename the column and take the brackets off?

If you want to use the column name in expressions like $(columnname) then column name should not have any spaces or any other special characters.