removing characters /space

[lapskaus]

how can i make a calculation field that takes the value of another field and removes all spaces between words in a string?

Example: I want "this and that" shown as "thisandthat".

[elvis_impersonating_penguin]

Substitute( FieldName , "what to replace" ,"replace with this" )

so it would look like this:

Substitute( FieldName , " " ,"" )

change Fieldname to the name of the original field.. i think this should work any.

[BobWeaver]

Use the Substitute() Function.

NewText = Substitute(OldText," ","")

[gmb]

how would this work for Carriage returns?, that is to remove them are replace with a space.

[timalex]

Greg

Substitute( Oldtext,"