topic Re: Formating Field in QlikView https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69875#M11524 <HTML><HEAD></HEAD><BODY><P>Hi Anil, thanks for the suggestion! But, I'm still getting the same issue.</P></BODY></HTML> Tue, 08 May 2018 13:14:25 GMT Anonymous 2018-05-08T13:14:25Z Formating Field https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69873#M11522 <HTML><HEAD></HEAD><BODY><P>Hi! I have a Supplier Number field that is including invisible quotes when exported to Excel (see screenshot below). <STRONG>How can I get these quotes removed?</STRONG></P><P></P><P>The field is pulled in as <SPAN style="color: #0000ff; font-size: 8pt;">text</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Supplier_Number</SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Supplier_Number </SPAN></P><P>and displayed in a chart as a dimension: <SPAN style="color: #0000ff; font-size: 8pt;">SubStringCount</SPAN><SPAN style="font-size: 8pt;">('|' &amp; </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">%Dimensions</SPAN><SPAN style="font-size: 8pt;">, '|') &amp; '|', '|Supplier Number|') </SPAN></P><P></P><P>The field does contain alphanumeric values.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201838_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 08 May 2018 12:55:12 GMT https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69873#M11522 Anonymous 2018-05-08T12:55:12Z Re: Formating Field https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69874#M11523 <HTML><HEAD></HEAD><BODY><P>Can you try this?</P><P></P><P><SPAN style="color: #000000; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>Trim(Replace(Text</STRONG></SPAN><STRONG style="color: #000000; font-size: 10pt; font-family: arial, helvetica, sans-serif;">(Supplier_Number), Chr(34), ' ')) as </STRONG><SPAN style="color: #000000; font-size: 10pt; font-family: arial, helvetica, sans-serif;"><STRONG>Supplier_Number</STRONG></SPAN></P></BODY></HTML> Tue, 08 May 2018 12:58:58 GMT https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69874#M11523 Anil_Babu_Samineni 2018-05-08T12:58:58Z Re: Formating Field https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69875#M11524 <HTML><HEAD></HEAD><BODY><P>Hi Anil, thanks for the suggestion! But, I'm still getting the same issue.</P></BODY></HTML> Tue, 08 May 2018 13:14:25 GMT https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69875#M11524 Anonymous 2018-05-08T13:14:25Z Re: Formating Field https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69876#M11525 <HTML><HEAD></HEAD><BODY><P>Can you provide sample to demonstrate the issue?</P></BODY></HTML> Tue, 08 May 2018 13:24:42 GMT https://community.qlik.com/t5/QlikView/Formating-Field/m-p/69876#M11525 Anil_Babu_Samineni 2018-05-08T13:24:42Z