How to remove the last "n" strings

[sharvan029]

Hi,

I wanted remove last two characters from the string 'demo"}' ie, i want to remove " and }

I tried using the below code but its not working

LEFT([column],,(LEN([column])-2)) and its not working .. can anyone help me please on this pls

[gooranga1 · Accepted solution]

It is definitely a column and not a measure? Do you get an error or blank?

[gooranga1]

try left([column],(LEN([column])-2)) with 1 comma.

[sharvan029]

There is actually one comma .. still. not working

[gooranga1 · Accepted solution]

It is definitely a column and not a measure? Do you get an error or blank?

[sharvan029 · Accepted solution]

It works , the error was because i had some null values in my column
Thanks a lot @gooranga1 for your help ..

[v-yuezhe-msft]

@sharvan029,

Glad to hear the issue is solved, you can accept appropriate reply as answer to close this  thread.

Regards,
Lydia