Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Subfield function

Hi   Experts ,

I have EMAIL ID field but it contain two email id's in one row so i want to pick only first email id which is preceding of  '/' and ','.So how can i use sub field function for both.I have attached my sample qvw.(How can i use subfield function multiple times for single column)

Example                   

EMAIL ID                                                                                             Expected OUTPUT

smartrituenterprise@gmail.com/sumanroy@hotmail.com                (smartrituenterprise@gmail.com)

sam8698370@gmail.com,org2004@yahoo.co.in                              (sam8698370@gmail.com)

Thanks in advance

Regards,

RUP

stalwar1kaushik.solanki

Tags (1)
6 Replies
Highlighted
Specialist
Specialist

Re: Subfield function

=if(index(EMAILID,'/') > 0,SubField(EMAILID,'/',1),SubField(EMAILID,',',1))

Highlighted

Re: Subfield function

Hi,

another solution for multiple possible email delimiters might be:

QlikCommunity_Thread_269085_Pic1.JPG

A:

Load *,

    Left(EMAILID,FindOneOf(EMAILID&',','/, ;')-1) as FIRSTEMAILID

INLINE [

    EMAILID

    "sd8698370@gmail.com,org2454@yahoo.co.in"

    "a_shivekar@yahoo.co.in,datta.shivekar@ethoswatches"

    "haraakirankaur415@gmail.com,SUKHWANT.SINGH@INDIA.COM"

    "malikbj2055@yahoo.com,malikbj2055@gmail.com"

    "nandkishorsable@hotmail.com,rekhansable@gmail.com"

    "NUNU.ANGEL@GMAIL.COM, ANU14096@GMAIL.COM"

    emmanuel2427@gmail.com/emmanuelbijapurkar@gmail.co

    mysticalimpressions@gmail.com/sabornee.karmakar@gm

    smartrituenterprise@gmail.com/sumanroy@hotmail.com

    09jayesh@gmail.com

    13NEGI@GMAIL.COM

    16MAYANKJAIN@GMAIL.COM

    0109PATILVIJAY@GMAIL.COM

    A.Khapli@gmail.com

    10johndoe@gmail.com 11janedoe@gmail.com

    12johnsmith@gmail.com;13janesmith@gmail.com

];

hope this helps

regards

Marco

Highlighted

Re: Subfield function

please close your open threads if your questions are answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco