How to display a field ending with the same alphabet

[BT]

I have a field(eventCode)  which has a code values, and few of them ends with certain alphabets , I want to extract only the eventCode which ends with E, F, V and display it separately under different fields/names(minor, major, medium). I tried with | where eventCode=*E, but this doesnot work.. Is there any other way to extract other than rex/regex. If not, can you please provide some input. 

Exmaple : eventCode=xyxbxsndsndg-5-3000-E

eventCode=aksjdjfdfvbrhgnvfmbfbc-54-3601-E

eventCode=plgkdfdcmasjenfmdklv-61-2501-F

eventCode= pojdksdjhmmmaskxjs-91-4501-V

Result : Minor                                                              Major                                                                        

xyxbxsndsndg-5-3000-E                                       plgkdfdcmasjenfmdklv-61-2501-F            

aksjdjfdfvbrhgnvfmbfbc-54-3601-E

[BT]

Works like a charm !!!! thank you 🙂 

[ITWhisperer · Accepted solution]

| where like(eventCode,"%E")