removing spaces from text field

[jobillborf]

Hi, I have a text field in my database formated "32 . 32" I would like to remove the space, period and space and have the result "3232" Can someone help me

Thank you for your help in advance.

 

[klewis10367]

Is that how the field is formatted for all data ie xx . xx?If so just do a ltrim([fieldname],2) + rtrim[fieldname,2]).

 

[lbass]

Or, if you have CR 8.5 or above, you should be able to use:

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

...but in CR 8.0, the replace function doesn't work well when trying to replace a character with "".

-LB