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!