How to remove special character (/) at the end of text (URL) field

[Nona]

Hi, anyone can help me ?

I would like to remove  [/] at the last of the text.  Text is like [test.com/sites/A0001/].

I would like to remove last [/] and make it to [test.com/sites/A0001].

Tried this one, but actually this remove all [/] form the text not only the last of [/]....

Column = SUBSTITUTE(ABCUser[SiteURL],right(ABCUser[SiteURL],1),"")

so end result is (test.comsitesA0001), which is not what I want...

[Ashish_Mathur]

Hi,

This is how it is done in the Query Editor

[Nona]

Thank you very much.  I first tried in query editor but could not find way.  Thanks !

[Ashish_Mathur]

You are welcome.  If my reply helped, please mark it as Answer.  

[amitchandak]

Take the 1 character using right and if it is  /, the use left

if(right (text,1)= "/", left(text,len(text)-1),text)

[Nona]

Thank you very much ! this works as well. and also different way of thinking.. I will remember this. Thanks !

[HotChilli · Accepted solution]

If the character is always at the end of the field, you could just remove the last character , eg,

NewColumn = LEFT(ABCUser[SiteURL], LEN(ABCUser[SiteURL]) - 1)

[Nona]

Thank you very much ! this works and very simple solution as well!