topic Re: How to remove inbetween characters from some records in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26812#M4489 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=SubField(YourField,'(',1)</P></BODY></HTML> Thu, 15 Feb 2018 05:36:33 GMT prma7799 2018-02-15T05:36:33Z How to remove inbetween characters from some records https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26811#M4488 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Can anyone please help on this?</P><P>I need to remove only these type of data from some records.</P><P>I don't want see the data from bracket "(". </P><P></P><P><IMG alt="2323.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193456_2323.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 15 Feb 2018 05:33:43 GMT https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26811#M4488 rkpatelqlikview 2018-02-15T05:33:43Z Re: How to remove inbetween characters from some records https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26812#M4489 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>=SubField(YourField,'(',1)</P></BODY></HTML> Thu, 15 Feb 2018 05:36:33 GMT https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26812#M4489 prma7799 2018-02-15T05:36:33Z Re: How to remove inbetween characters from some records https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26813#M4490 <HTML><HEAD></HEAD><BODY><P>Hi Kumar,</P><P>Please refer the below link</P><P></P><P> <A href="https://community.qlik.com/thread/252003">How to remove characters in between a string.</A></P><P></P><P>Many Thanks</P><P>Karthik</P></BODY></HTML> Thu, 15 Feb 2018 05:37:53 GMT https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26813#M4490 karthikoffi27se 2018-02-15T05:37:53Z Re: How to remove inbetween characters from some records https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26814#M4491 <HTML><HEAD></HEAD><BODY><P>Thanks Karthik,</P><P></P><P>It removed some records but not all. still there are some records and generated duplicates as well.</P><P><IMG alt="12124.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/193460_12124.PNG" style="height: auto;" /><IMG alt="111.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/193462_111.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 15 Feb 2018 05:56:49 GMT https://community.qlik.com/t5/QlikView/How-to-remove-inbetween-characters-from-some-records/m-p/26814#M4491 rkpatelqlikview 2018-02-15T05:56:49Z