replace a character with a characters

[Dani R]

If i get a filed with the data "hello.how.are.you"

how can I replace the text to "hello\how\are\you"

Thank you Dani

[Vaughan]

The Substitute() function will do this. Substitute( field ; "." ; "\" )

This can be use in script, a calculation field or the Replace command.