Taking spaces out of field name

[T1na]

We have a surname field that has two names in it e.g. Bob Jones the space is causing problems in validation. How do I take the space out and replace the space with a – so will receive the following result Bob-Jones.

 

[CR85user]

//{@surname}
replace({table.surname},' ','-')

You can use the same approach to omit spaces if required:

//{@surname}
replace({table.surname},' ','')

Good luck

'J

 

[Madawc]

Create a formula field saying

Replace({your.field}, " ", "-")

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10