Load Script - Compress strings with Spaces

Tue, 08 May 2012 15:19:51 GMT

Hi All

I am loading some data into a QVsolution. I have a postcode field which contains a postcodes with spaces in and ones without. In the load Script i an trying to iradicate this by using the function as you would in SAS. But this doesn't work.

COMPRESS(Postcode) AS POSTCODE,

I want to get all the strings that have a spave in them and remove the space. See example below

Original Data

ID	Postcode
1	WF4 4NQ
2	WF4 5TH

Desired Data

ID	Postcode
1	WF4 4NQ
2	WF4 5TH

Thanks

James

Load Script - Compress strings with Spaces

jagannalla — Tue, 08 May 2012 15:39:22 GMT

Hello,

Try this

LOAD ID, Replace(Postcode,' ','') as Postcode

;

topic Load Script - Compress strings with Spaces in QlikView

Load Script - Compress strings with Spaces

Load Script - Compress strings with Spaces