Replace "enter" while loading script

[Anonymous]

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 · Accepted solution]

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]

Yes, that it, thanks!