Right,

I have data that will becoming into a database form 2 csv files. (basically 2 distributors). They both over lap on supply to customers, but don't use the same name scheme.

So one could be Fred Bloggs Hospital Birmingham

The other could be FB Birmingham.

What I need to do is to add a second field that pics up certain aspects and creates a field that is then common to both.

Say it pics up F B Birmingham, and looks up and know that is Fred Bloggs Hospital Birmingham, and writes it into the new field.

This would then allow me to search both sets of data in the filemaker file, using a common refference.

But I can get it to work.

Cheers

Simon

How many variations on a hospital name might there be and could it vary within each csv file?

Phil

They will have one variation per spreadsheet and will not change.

The data is CSV's out of sage or similar!

Cheers

Simon

OK then, one last question to determine how I would tackle this - How many hospitals are there altogether?

Phil