topic Re: Remove - and Blank space in QlikView https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99117#M15838 <HTML><HEAD></HEAD><BODY><P>Have you tried <A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/PurgeChar.htm">PurgeChar()</A></P><P></P><P>Purgechar([Verification Area], '- ')</P></BODY></HTML> Wed, 18 Jul 2018 08:36:46 GMT tresB 2018-07-18T08:36:46Z Remove - and Blank space https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99115#M15836 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>I want to remove - in my table and also if there is LAB KPI is there, I need that should to display LABKPI.</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 154px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"></TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"></TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">VERIFICATION AREA</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;"></TH></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Area1</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">area51</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Certification</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CMCC_Specific</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CNT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CPD-CT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CPD-DT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CT-PS</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CT-RF</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CTPS</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">CTRF</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">DT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">DTNew Features_INTERNAL</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">eNB</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Field Test</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FRT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">FT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">HWMM</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">ICT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">IODT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">iVP</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">LAB-KPI</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Lab Infra</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Lab KPI</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">LabKPI Infra</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">LabKPI Simulator</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">MFT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Modem Legacy Features</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NV-IOT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NV-IOT-FDD</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NV-IOT-TDD</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NV-IOT-TDS</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NV-IOT_In-House</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">NVIOT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">OP-IOT</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">PS-FW SubSystem</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">PSSI_Lab</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">QVDev</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Release Test</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">RF KPI</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Simulation</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Stability</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">System KPI</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">System Test</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">System Verification</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">System_Regression</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">TDSRMM</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR><TR><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">Training</TD><TD class="xl65" height="17" style="border-top: none; color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 18 Jul 2018 07:22:43 GMT https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99115#M15836 sona_sa 2018-07-18T07:22:43Z Re: Remove - and Blank space https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99116#M15837 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: inherit; font-weight: inherit;"><SPAN style="font-family: inherit; font-size: 13.6px; font-style: inherit; font-weight: inherit;">PurgeMap</SPAN>:<BR />MAPPING LOAD * <SPAN style="font-family: inherit; font-size: 13.6px; font-style: inherit; font-weight: inherit;">INLINE</SPAN> [ </SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: 'courier new'; font-weight: inherit;">char replace<BR />-<BR />_</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: 'courier new'; font-weight: inherit;"> <BR />] (delimiter is ‘ ‘)<BR />; </SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: 'courier new'; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: 'courier new'; font-weight: inherit;">[Verification Area]:</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 13.6px; font-family: 'courier new'; font-weight: inherit;">Load<BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;">MapSubString(‘PurgeMap’, [Field Name]) as [New Field Name];</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;">Load * inline</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;">[</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;">Field Name</SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: #2b2b2b; font-style: inherit; font-size: 16px; font-family: 'courier new'; font-weight: inherit;">]<BR /></SPAN></P><P>;</P></BODY></HTML> Wed, 18 Jul 2018 07:33:57 GMT https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99116#M15837 ujjwalraja 2018-07-18T07:33:57Z Re: Remove - and Blank space https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99117#M15838 <HTML><HEAD></HEAD><BODY><P>Have you tried <A href="https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringFunctions/PurgeChar.htm">PurgeChar()</A></P><P></P><P>Purgechar([Verification Area], '- ')</P></BODY></HTML> Wed, 18 Jul 2018 08:36:46 GMT https://community.qlik.com/t5/QlikView/Remove-and-Blank-space/m-p/99117#M15838 tresB 2018-07-18T08:36:46Z