Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rupaliqlik
Creator
Creator
‎2017-07-26 01:16 PM

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

stalwar1‌kaushik.solanki‌

Sunfield in Emailid.qvw
1,570 Views
0 Likes
6 Replies
ziadm
Specialist
Specialist
‎2017-07-26 02:36 PM

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

919 Views
MarcoWedel
MVP
MVP
‎2017-07-27 05:36 PM

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

QlikCommunity_Thread_269085.qvw
919 Views
MarcoWedel
MVP
MVP
‎2017-08-02 03:22 PM

please close your open threads if your questions are answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

919 Views