Remove spaces from text

[ajr1705]

Is there a formula I can use to remove all spaces. I have used the trim command but I want all spaces removed thus from with the text.

E.g " AA xx"

required data "AAXX"

 

[synapsevampire]

Try:

replace({table.field}," ","")

And if you've numerous, nest them, as in:

replace(replace({table.field}," ","")," ","")

Or you can loop:

whileprintingrecords;
stringvar Output:="";
numbervar counter;
for counter = 1 to len({table.field}) do(
if mid({table.field},counter,1) <> " " then
Output:=Output+mid({table.field},counter,1)
);
Output

-k

 

[ajr1705]

Boss sorry for the late reply.

Thanks for the help.