I have a column contains some unwanted value and I want to remove it.
Example data.
%,VApple
%,VBlueBerry,NOrange
%,FPineapple,TWaterMelon,XStrawberry,NMango
Result want to get
Apple
Orange
Mango
It is always the last word after the comma with a character(V or N)
Any help is appreciated!
Bookmarks