Connecting Tech Pros Worldwide Forums | Help | Site Map

Merge Text Files

Steve
Guest
 
Posts: n/a
#1: Nov 12 '05
My application uses transfertext to create text files that are FTPed to a
website and are processed by a webstore. The text files can be for one of three
purposes: Add one or more items to the webstore, Update one or more existing
items in the webstore or delete one or more items from the webstore. The Add
text files begin with ADD in the first field to signal the webstore to add the
item, the Update textfiles begin with UPDATE in the first field to signal the
webstore to update the item in the record and the Delete text files begin with
DELETE in the first field to signal the webstore to delete the item in the
record. An ADD text file contains the ADD field plus 25 fields, an Update
textfile contains the UPDATE field, the name of the field to update and the
update value and a Delete textfile contains the DELETE field and the primary key
of the record to delete. If all three processes need to be carried out,
currently three separate text files are created, separately FTPed to the website
and separately processed by the webstore. Is there a way to merge the text files
if there is more than one process to carry out such as:

Add ---- 25 fields
Add ---- 25 fields
Update Field2 15
Update Field7 12
Delete Field1

Thanks!

Steve



Closed Thread