https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742392#M56837 <P>May be it is Chr(160), try this</P><P>PurgeChar(FieldName, Chr(160)) and see if this works</P> Wed, 09 Sep 2020 12:19:11 GMT sunny_talwar 2020-09-09T12:19:11Z https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742386#M56834 <P>Hi all,</P><P>I am trying to remove a blank space of a string which was loaded from an Excel file into Qlik Sense via the Data Load Editor.</P><P>The string in the Excel column basically looks like this: "123a " (with a blank space at the end)</P><P>I already tried several functions e.g. trim, rtrim, replace, and&nbsp;<SPAN>PurgeChar. Unfortunately, nothing works.</SPAN></P><P>Does anyone have an idea how to solve this?</P><P>Thanks in advance.</P> Sat, 16 Nov 2024 18:07:50 GMT https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742386#M56834 vlntn 2024-11-16T18:07:50Z https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742392#M56837 <P>May be it is Chr(160), try this</P><P>PurgeChar(FieldName, Chr(160)) and see if this works</P> Wed, 09 Sep 2020 12:19:11 GMT https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742392#M56837 sunny_talwar 2020-09-09T12:19:11Z https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742398#M56838 <P>That worked. Thank you!</P> Wed, 09 Sep 2020 12:26:18 GMT https://community.qlik.com/t5/App-Development/Remove-blank-space-in-a-string-from-a-Excel-file-in-the-data/m-p/1742398#M56838 vlntn 2020-09-09T12:26:18Z