Replacing specific occurrences of a search string

[ShannonM]

Hello,

I am attempting to create a calculation that allows me to replace specified occurrences of a search string.

For example, say I have a field that contains a list of names:

John, Sarah, Henry, John, Chris, David, John, Mary.

I want to be able to substitute the second and third occurences of "John" with the text: "John(duplicate)".

I hope this is clear enough.

Thanks in advance!

[Søren Dyhr]

A list of names shouldn't occure - 1 NF:

http://en.wikipedia.org/wiki/Database_normalization

This means breaking it out in separate records is the way to go, and when it's done:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000744

--sd