Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a situation where I need to pull only 4 characters [ZZZZ] before @ symbol in the email formats shown below
Tom.x.harry.peter.ZZZZ@gmail.com
Tom.x.harry.peter.o.ZZZZ@gmail.com
I tried below but it works for only one situation
subField(SubField(upper(Column1),'.',3),'@'.1)
Looking forward for the lead
Thanks very much.
Both suggestions seems to be working
Table:
LOAD *,
SubField(SubField(Email, '@', 1), '.', -1) as NewField,
Mid(Email, Index(Email, '@')-4,4) as NewField2;
LOAD * INLINE [
Tom.x.harry.peter.ZZZZ@gmail.com
Tom.x.harry.peter.o.ZZZZ@gmail.com
];
The one in Red is proposed by Anil and the one in Blue is by Neelam.
How about this:
=Mid(Mail, Index(Mail, '@')-4,4)
Nopes that doesn't work I tried it
Thanks very much for the above suggestion Neelam
How about this?
=SubField(SubField(FieldName,'@', 1),'.',-1)
Both suggestions seems to be working
Table:
LOAD *,
SubField(SubField(Email, '@', 1), '.', -1) as NewField,
Mid(Email, Index(Email, '@')-4,4) as NewField2;
LOAD * INLINE [
Tom.x.harry.peter.ZZZZ@gmail.com
Tom.x.harry.peter.o.ZZZZ@gmail.com
];
The one in Red is proposed by Anil and the one in Blue is by Neelam.
These work Guys, thanks very much for your help
Much appreciated Anil, Sunny and Neelam
Please mark Neelam/Anil's response as correct because I simply took there expressions and create a script for you. or at least mark there responses as helpful as they put in the effort to come up with the correct response and as I just showed, both the responses seems to be working.
Thank you,
Sunny