topic Re: Can I remove characters after a specific symbol? in QlikView https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/1645585#M447499 <P>Tack Henrik! (Thank you)</P> Mon, 11 Nov 2019 21:41:52 GMT Uri 2019-11-11T21:41:52Z Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641479#M235006 <HTML><HEAD></HEAD><BODY><P><BR />I need to format our product codes so that :</P><P></P><P>4233702/1001100</P><P>EN42343EX/1013100</P><P></P><P>Become:</P><P>4233702</P><P>EN42343EX</P><P></P><P>Removing everything after the forward slash. Can I do this via Qlikview scripting?</P></BODY></HTML> Wed, 21 May 2014 10:13:21 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641479#M235006 2014-05-21T10:13:21Z Re: Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641480#M235007 <HTML><HEAD></HEAD><BODY><P>Left(FieldName, Index(FieldName, '/') - 1)</P><P></P><P>HIC</P></BODY></HTML> Wed, 21 May 2014 10:15:19 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641480#M235007 hic 2014-05-21T10:15:19Z Re: Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641481#M235008 <HTML><HEAD></HEAD><BODY><P>Many thanks Henric. Worked a treat <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 21 May 2014 10:17:53 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/641481#M235008 2014-05-21T10:17:53Z Re: Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/1645585#M447499 <P>Tack Henrik! (Thank you)</P> Mon, 11 Nov 2019 21:41:52 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/1645585#M447499 Uri 2019-11-11T21:41:52Z Re: Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/1933344#M1219054 <P>Hi, What if I need to keep rest text after the email e.g.</P> <P>Original&nbsp; Text : My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball@amazon.com</A>. Please Contact.</P> <P>Desire Replace Text:&nbsp;My Email is&nbsp;<A href="mailto:Tim.Kimball@amazon.com" target="_blank" rel="nofollow noopener noreferrer">Tim.Kimball</A>****. Please Contact.</P> Fri, 20 May 2022 01:52:54 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/1933344#M1219054 Bionic 2022-05-20T01:52:54Z Re: Can I remove characters after a specific symbol? https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/2006428#M1221548 <P>Thanks, needed the exact same thing&nbsp;<span class="lia-unicode-emoji" title=":beaming_face_with_smiling_eyes:">😁</span></P> Fri, 18 Nov 2022 13:21:21 GMT https://community.qlik.com/t5/QlikView/Can-I-remove-characters-after-a-specific-symbol/m-p/2006428#M1221548 thestaffsolutions 2022-11-18T13:21:21Z