Find and replace specific characters

[Brett Clark 0]

I have a database with a field that currently has a list of items separated by a semi-colon and a space. (item 1; item 2; item 3; item 4) I want to replace the semi-colon with another character. Is there a way to search for a specific character or word in a field, and replace with another character or word.

Thanks,

Brett

flash_test.fp7.zip

[BobWeaver 1]

ModifiedText = Substitute(OriginalText,";",NewCharacter)