Load Script - Compress strings with Spaces

[#1]

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

[jagannalla · Accepted solution]

Hello,

Try this

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

;