Flush FIELD CONTENTS from one record to next

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

eboughey
Posts: 2
Joined: Thu Mar 06, 2014 4:18 am

Flush FIELD CONTENTS from one record to next

Postby eboughey » Thu Mar 06, 2014 4:44 am

I noticed too late that when I converted my file that the information from the previous record was propogating to the next record if the field was empty in that record.

Is there any way to fix this issue? Each record is different and it doesn't always have info. This is particularly distressing since I'm using APR rates and financial information.

eboughey
Posts: 2
Joined: Thu Mar 06, 2014 4:18 am

Re: Flush FIELD CONTENTS from one record to next

Postby eboughey » Fri Mar 07, 2014 9:23 am

Isn't there anyone who knows how to do this? I can't imagine that you can't flush the field contents from the record after it's done so the next one starts with a clean slate.

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

Re: Flush FIELD CONTENTS from one record to next

Postby DataMystic Support » Tue Mar 11, 2014 12:39 pm

Hi - it depends how you do it.

If you use a search/replace, and capture data to a capture filter, then yes, you can clear the contents between records, if for example, you limit TextPipe to one line at a time (see Reestrict to line at a time). This is the best approach, because TextPipe streams the data and does not care about line or record breaks.

An alternative approach would be to use $1, $2 etc instead of named globals like @interest_rate@, @address1@ etc.

I believe a useful improvement would be for TextPipe to clear all named globals prior to a match. What do you think?
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 2 guests