Need to combine 4 text files into 1.

[diane]

I have 4 text files that I need to combine together. File 1 - has names and date of birth, File 2 - has addresses, File 3 - Service Type, File 4 - Insurance info. They all contain a Patient number that I can join by. Can someone please help??

[Grant Perkins]

Diane,

Some questions,

Are you wanting to use Monarch to combine the files or would any method do?

Do you have any (or is there anyone with) relevant programming/scripting experience that you can call on?

Which version of Monarch do you have access to?


Are the files basic text files (as from a word processor for example) or are they delimited text files that could be used as a source for a database?

The best approach for you to take will depend somewhat on the answers. There are several approaches that will work.

I look forward to your update.

Grant



Originally posted by diane:
I have 4 text files that I need to combine together. File 1 - has names and date of birth, File 2 - has addresses, File 3 - Service Type, File 4 - Insurance info. They all contain a Patient number that I can join by. Can someone please help??