Batch Mode - Text File database - update value

General discussions about Advanced Find and Replace
Post Reply
dshepard
Posts: 1
Joined: Fri Apr 22, 2005 5:00 am

Batch Mode - Text File database - update value

Post by dshepard » Fri Apr 22, 2005 5:11 am

I have a raw text file that is a database (1 record per row) - containing account numbers, dollar amounts, and other items. I would like to update this Text File Database with data from the line 'above' if the account numbers are the same for a new field - sample below

incoming
account# Check# CheckAmount Ending Balance
123456 12345 27.54 5987.62
123654 8761 14.34 890.65
123654 8765 87.55 817.44
123654 8790 101.23 803.76
123654 8801 914.12 9.13-
------------------------------------------------------------
outgoing
account# Check# CheckAmount Ending Balance New Balance
123456 12345 27.54 5987.62 5987.62
123654 8761 14.34 890.65 890.65
123654 8765 87.55 817.44 803.10
123654 8790 101.23 803.76 701.87
123654 8801 914.12 9.13- 212.25-

Can you do this in Abacre?

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests