Merge 2 files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

mfauzim
Posts: 1
Joined: Mon Mar 27, 2006 1:34 pm

Merge 2 files

Postby mfauzim » Mon Mar 27, 2006 1:37 pm

I have 2 files. File A is ther reference data with column id and name
file 2 is detail log data with date, id , etc

Can Textpipe merge these 2 files based on id and output into third file c with data, id , name( from file A) and other fields

regards

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Thu Mar 30, 2006 9:28 am

This is best done with a database.

The way to do this in TextPipe would be to use a VBScript. This would load the entire File A into an associative array, and then supply the correct Name field data as the id field of File B was examined.

Does that help?
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest