To cahnge from ":" to "/"

[Dani R]

Hello i get from a date base in my office (sql) a filed that the contents of it is:

example :"hello:how:are:you"

how can i change to "hello/how/are/you"

thank you

Dani R

[bcooney]

Substitute ( "hello:how:are:you" ; ":" ; "/" )

[beverly]

or:

Substitute ( anyfieldname; ":" ; "/" )

the default is all matches.