JoinLine

JoinLine helps you fixe text files with long fixed length records and unwanted line wraps JoinLine helps you fix text files with long fixed length records and unwanted line wraps. Spreadsheets and database programs import individual text records with data on the same line. However, sometimes text lines are wrapped before the end of the record. If these records always wrap to the same number of lines, then JoinLine can restore the wrapped records to single line records. For example - suppose a data set has fixed length text records of 200 characters and when the records are transferred the transfer program inserts unwanted line-returns to enforce all lines to be less that 80 characters.

Then each text record becomes 2 lines of 80 characters and 1 line of 40 characters. That is, each text record has been broken into 3 lines. JoinLine can fix this by merging each sequential group of 3 lines into the original single line record. A space pad character can be inserted between merged lines; input lines can be padded to a minimum length; and non-printing characters can be translated to spaces. JoinLine writes the merged line result to a new file or appends to an existing file.