TRIM DATA on DATA MANAGEMENT

Content

Hello,

I've got a file which has been extracted from source with an space character on the numeric data as the thousand separator.

When importing, if the file type is set as "Numeric data" in the import format, data management will remove those lines with the space character. 

So I've set the file type as "all data type" and all lines are getting imported.

Now I'm trying to remove the blank spaces with a SQL mapping but it's not working.

This is the code:

CASE
WHEN DATA LIKE '% %' THEN '%'
ELSE
DATA
ENDCASE

I've also tried with AMOUNTX instead of data , but still no lucky.