I am converting an EBCDIC file complete with packed decimal. Someone thought of the bright idea of putting 2 record types in the outpt file sent to me. The file is fixed with and in field position 54 is equal to 1 its one record type and its not equal to 1 then its the other record type. I have filters set up like so.
restrict to block length 100
....restrict bytes 76-79
.......expand packed decimal
Convert to EBCDIC
...
All I need to do is skip the expand packed decimal if position 54 equals 1 and I am set to go. Any suggections how I might do this.
Skipping filters based on field value
Moderators: DataMystic Support, Moderators
- DataMystic Support
- Site Admin
- Posts: 2229
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Inside your restrict to block lenght 100, use two pattern matches as a restriction.
The first matches '1' records:
.{53}1.{46}
Inside this put your expand packed decimal expansion.
The other matches not '1' records
.{53}[^1].{46}
The first matches '1' records:
.{53}1.{46}
Inside this put your expand packed decimal expansion.
The other matches not '1' records
.{53}[^1].{46}
Regards,
Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads
Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads