Re: ASCII NUL removal - Qlik Community

haymarketpaul · ‎2020-09-23

QV12 SR4

I've got a simple load script that ultimately exports a pipe delimited txt file for importing into Google Big Query.

Google Big Query is moaning that the file contains ASCII NUL characters

Any idea how to remove or replace them in the Qlik load script?

Brett_Bleess · ‎2020-10-20

Believe the following Help Doc link may get you what you need, but I am not certain.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/NULLF...

Should be able to find the Nulls and replace them with something Big Query should like...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

haymarketpaul · ‎2020-10-20

Ah thanks I'd given up on this post - I'll take a look and see if that does the trick