# Merge TPS files

**URL:** <https://clarionhub.com/t/merge-tps-files/1013>\
**Category:** questions\
**Created:** [February 24, 2017, 11:41pm UTC](https://clarionhub.com/t/merge-tps-files/1013 "2017-02-24T23:41:16Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![vitesse](https://clarionhub.com/user_avatar/clarionhub.com/vitesse/32/837_2.png) [@vitesse](https://clarionhub.com/u/vitesse)\
**Post date:** [December 7, 2023, 10:32pm UTC](https://clarionhub.com/t/merge-tps-files/1013/9 "2023-12-07T22:32:34Z")

</div>

> [@CarlBarnes](#):
>
> Seems like it could be done with 1 FILE by saving the Records into a Queue.

> [@CarlBarnes](#):
>
> Instead you could write it to a DOS file if you were concerned about memory limits.

perhaps writing out to JSON or XML then reading that back in?

perhaps the hardest part is “to create a program which will take a random tps file” as you need to be able to open and read this file without knowing the structure in advance. There used to be a library that did that - see

> [@Is DynaLib still Available?](https://clarionhub.com/t/is-dynalib-still-available/6052/5):
>
> Hi Donald I tried to buy it from Oleg Rudenko a few years back, but it proved very difficult to transfer funds and I gave up in the end. (I think I tried and failed with TransferWise and PayPal). Note this was before the 2022 Russian invasion of Ukraine and the subsequent tightening of restrictions on money transfers so I suspect it would be absolutely impossible now. The details at the time: The library’s source code is available for purchase. Last version - v5.0.4.6 - C50b / C55h / C63.…

for info on my attempt to buy DynaLib many years back. There is plenty of information about the structure of a tps file so it should be possible to “roll your own” but perhaps more work than the OP wants to do:

> [@TPS internal file structure](https://clarionhub.com/t/tps-internal-file-structure/3706):
>
> There are a number of posts about this topic on the net. This one (attachment) was 404d, so Ive added it here so it doesnt get lost. [42 Blog - Liberating data from Clarion TPS files.pdf](https://clarionhub.com/uploads/short-url/ekTqgoRmAeNQNGRFgRIfCSF9Rz.pdf) (113.5 KB)

hth

Geoff

---

_[View the full topic](https://clarionhub.com/t/merge-tps-files/1013)._
