https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453604#M98265 <P>In the load script, for each field you're loading, use one of these options:</P> <P>&nbsp;</P> <P>Option 1: If all rows have the [[]]:</P> <P>TextBetween(Mach, '[[', ']]') As Mach</P> <P>&nbsp;</P> <P>Option 2:</P> <P>Replace(Replace(Mach, '[[', ''), ']]', '') as Mach</P> <P>&nbsp;</P> <P>Just adapt to your load script and to each field and you're good.</P> Fri, 17 May 2024 11:01:25 GMT igoralcantara 2024-05-17T11:01:25Z https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453582#M98263 <P>Hello,</P> <P>I have CSV file data. In the data, I want to remove all [[ ]].</P> <P>Please help with it.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Suraj_Kendre_0-1715941020460.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/166313iF63B6E4B4C8263E4/image-size/medium?v=v2&amp;px=400" role="button" title="Suraj_Kendre_0-1715941020460.png" alt="Suraj_Kendre_0-1715941020460.png" /></span></P> <P>&nbsp;</P> Fri, 15 Nov 2024 20:58:08 GMT https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453582#M98263 Suraj_Kendre 2024-11-15T20:58:08Z https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453604#M98265 <P>In the load script, for each field you're loading, use one of these options:</P> <P>&nbsp;</P> <P>Option 1: If all rows have the [[]]:</P> <P>TextBetween(Mach, '[[', ']]') As Mach</P> <P>&nbsp;</P> <P>Option 2:</P> <P>Replace(Replace(Mach, '[[', ''), ']]', '') as Mach</P> <P>&nbsp;</P> <P>Just adapt to your load script and to each field and you're good.</P> Fri, 17 May 2024 11:01:25 GMT https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453604#M98265 igoralcantara 2024-05-17T11:01:25Z https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453615#M98266 <P>Use PurgeChar() like</P> <P>=PurgeChar(Mach, '[[]]')</P> Fri, 17 May 2024 11:32:10 GMT https://community.qlik.com/t5/App-Development/Unwanted-data-remove/m-p/2453615#M98266 BrunPierre 2024-05-17T11:32:10Z