Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Replace ASCII character 2 (STX, Start of text) with blanks


We import Microsoft Axapta data from an Oracle db. Empty values aren't filled with the value NULL or a space but with an ascii character 2 ( chr(2) ). This character means 'Start of text'. Qlikview shows a square. Our goal is to change this value in an empty string value.

We can use the PurgeChar function for each field of each table. This will be a lot of work. Is there a command or a function we can use in the beginning of our script to do a replace for every instances of our database? Otherwise, can we loop through every table and every field to do a PurgeChar after loading of all the tables?

Kind regards,


1 Reply
Not applicable

Re: Replace ASCII character 2 (STX, Start of text) with blanks


I think is better to purche character in every record insted modify Axapta Database.

i hope to help you