Jump to content

Replacing specific occurrences of a search string


This topic is 6077 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6077 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.