filter based on record type column in file?

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Posts: 4
Joined: Fri Mar 12, 2010 7:11 am

filter based on record type column in file?

Postby lindakampa » Fri Mar 12, 2010 7:15 am

Hi - I am fairiy new to TextPipe Pro. We have EBCDIC files we are using TextPipe Pro to convert to tab-delimited ASCII files.

I have a file that has various record types (this is field #4 in the tab delimited file). There are different layouts in the copybook that relate to this record type. Essentially I have one input file, with 4 or 5 record types, that I would like to process into separate files.

What is the best way to filter based on the record type column?

Thanks for your help!


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

Re: filter based on record type column in file?

Postby DataMystic Support » Fri Mar 12, 2010 10:11 am

Hi Linda,

Please see the attachment for the general approach.

Essentially you create a restriction - one per record type. Inside this you place the copybook for just that record type, and generally, you output the result to a new file for each record type.
(138.77 KiB) Downloaded 248 times

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: Bing [Bot] and 2 guests