Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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,
Sander
Hi,
I think is better to purche character in every record insted modify Axapta Database.
i hope to help you