https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1746369#M590713 <P>QV12 SR4</P><P>I've got a simple load script that ultimately exports a pipe delimited txt file for importing into Google Big Query.</P><P>Google Big Query is moaning that the file contains ASCII NUL characters</P><P>Any idea how to remove or replace them in the Qlik load script?</P> Sat, 16 Nov 2024 18:04:24 GMT haymarketpaul 2024-11-16T18:04:24Z https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1746369#M590713 <P>QV12 SR4</P><P>I've got a simple load script that ultimately exports a pipe delimited txt file for importing into Google Big Query.</P><P>Google Big Query is moaning that the file contains ASCII NUL characters</P><P>Any idea how to remove or replace them in the Qlik load script?</P> Sat, 16 Nov 2024 18:04:24 GMT https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1746369#M590713 haymarketpaul 2024-11-16T18:04:24Z https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1754139#M590714 <P>Believe the following Help Doc link may get you what you need, but I am not certain.&nbsp;&nbsp;</P><P><A href="https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/IsNull.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/IsNull.htm</A></P><P>Should be able to find the Nulls and replace them with something Big Query should like...</P><P>Regards,<BR />Brett</P> Tue, 20 Oct 2020 14:10:28 GMT https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1754139#M590714 Brett_Bleess 2020-10-20T14:10:28Z https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1754140#M590715 <P>Ah thanks I'd given up on this post - I'll take a look and see if that does the trick</P> Tue, 20 Oct 2020 14:14:22 GMT https://community.qlik.com/t5/QlikView/ASCII-NUL-removal/m-p/1754140#M590715 haymarketpaul 2020-10-20T14:14:22Z