Merge 2 files

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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


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

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?

Simon Carter, - Insulin dose calculator for Type 1 diabetes - 250,000 free software downloads - send huge email attachments

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

Who is online

Users browsing this forum: Majestic-12 [Bot] and 1 guest