SubField issue on Qlikview

[remo0017]

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.ZZZZ@gmail.com

Tom.x.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.

[neelamsaroha157]

How about this:

=Mid(Mail, Index(Mail, '@')-4,4)

[remo0017]

Nopes that doesn't work   I tried it

Thanks very much for the above suggestion Neelam

[Anil_Babu_Samineni]

How about this?

=SubField(SubField(FieldName,'@', 1),'.',-1)

[sunny_talwar · Accepted solution]

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 [

  Email

    Tom.x.harry.peter.ZZZZ@gmail.com

    Tom.x.harry.ZZZZ@gmail.com

    Tom.x.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.

[remo0017]

These work Guys, thanks very much for your help

Much appreciated Anil, Sunny and Neelam

[sunny_talwar]

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