topic Replace "enter" while loading script in QlikView

Replace "enter" while loading script

Anonymous — Thu, 02 Dec 2010 14:36:39 GMT

Hi experts 🙂

I am trying to get adresses from my database by using this code


Debiteur_Adres:
LOAD adres,
 plaats,
 postcode;
SQL SELECT *
FROM DATA.PUB."ba-012";

This works fine, only the field "adres" can contain multiple lines, seperated by an "enter" ( chr(10) )

I want to have all these chr(10) 's replace by a comma while loading the script.

Any suggestions?

googel84 — Thu, 02 Dec 2010 15:10:48 GMT

I tried with a simple excel file and the following load statement worked fine.

LOAD
replace(adres,chr(10),','),
plaants,
postcode;
SQL SELECT ...

Hope it helps.

Anonymous — Thu, 02 Dec 2010 15:20:16 GMT

Yes, that it, thanks!