TextBetween some symbols

[#1]

Hi Friends,

Please help me.. This is urgent for me...

I have a feild having values like below:-

Name

shamly.gmail.com

abc_shamly.gmail.com

kevin.gmail.com

abc_george.gmail.com

abc_def_shamly.gmail.com

abc_shamly

shamly

kevin

george

I need only the nams from all the feilds. Some name entries are there as default(kevin, shamly, george). I need those as such and shamy from other entries which has '_ 'and '.'   . So I used TextBetween function. But it is not giving me for all. Please help me to get only NAME from all the given possibilities of name entries.

I tried this trim(UPPER(subfield(Name,'.',1)))

I tried this also UPPER(TextBetween(NAME, '_', '.',1))

Please help me quickly friends... this is vey important for me today

Message was edited by: Shamly P.T

[evan_kurowski]