Sequential flat file terminates early on some records
Posted: Tue Aug 28, 2007 6:02 pm
I've seen several near-similar posts to this, but not this problem exactly.
I'm reading in a flat fixed width sequential file to a server job. Most records have the correct length. But a few have an early terminator, which breaks the remainder of the record off into a new, shorter record.
By changing some of the parameters in the sequential file properties, i'm able to successfully read the file. But I'd like to put it back out with every line the same length. I've tried using various parsings, using EReplace to remove the early terminator, etc., all to no avail. Does anyone have a suggestion as to how I might remove the early terminator and put out all records the same length?
Thanks for any suggestions.
Tom Smith
I'm reading in a flat fixed width sequential file to a server job. Most records have the correct length. But a few have an early terminator, which breaks the remainder of the record off into a new, shorter record.
By changing some of the parameters in the sequential file properties, i'm able to successfully read the file. But I'd like to put it back out with every line the same length. I've tried using various parsings, using EReplace to remove the early terminator, etc., all to no avail. Does anyone have a suggestion as to how I might remove the early terminator and put out all records the same length?
Thanks for any suggestions.
Tom Smith