Removing / from the end

[mmustkee]

Hi Team,

I need to remove '/' from the end of the word. Please refer below and remove '/' which are coming  in the end in the column Absent. and from column Present, please delete all 'st' if they come in the beginning for each slash.

I have updated result as well for both the column.

Absent	Present	Result Absent	Result Present
a/w/r///////	stsdf/stgrf/rsw/stred	a/w/r	sdf/grf/rsw/red
d/2//////	stsdf/stgrf/rsw/stred	d/2	sdf/grf/rsw/red
3/d/g/////	dsrst/sters/rests/stdre	3/d/g	dsrst/sters/rests/dre
s/d//		s/d
r/d/d/		r/d/d
rd/s/////////////	rd/s
sd/d		sd/d

[binuacs]

@mmustkee 

Spoiler

[Qiu]

@mmustkee 
@binuacs has provided a perfect solution, and I just tried another Regex approach.
Hope it will also helo.

[mmustkee]

@binuacs 

Thanks for your solution removing slash worked fine but I can see that 'st' is still there in the beginning. Please refer highlighted.

[mmustkee]

@Qiu 

Thanks for the solution, I can still see 'st' after second slash and third slash. Please refer highlighted

[Qiu · Accepted solution]

@mmustkee 
Sorry that I was not being careful enough. 😅

[mmustkee]

@Qiu 

Perfect!  you are always great

Thanks 

[Qiu]

@mmustkee 
Glad to help and thank you for accepting my answer.😁