<div>
<div class="content wysiwyg-content">
I have a text file with uneven lines i.e. The first line ends at 185 characters and the next at 201 characters and so on.<br />
I need a way to pad the short lines to the length of the longer lines so I can BULK INSERT into SQL with a format file (.fmt).<br />
The format file uses &quot;\r\n&quot; to find the end of each line so the CrLf has to be in the same place at the end of each line.<br />
I need a batch file to count the columns and insert spaces for the shorter lines.
</div>
</div>


I have a text file with uneven lines i.e. The first line ends at 185 characters and the next at 201 characters and so on.
I need a way to pad the short lines to the length of the longer lines so I can BULK INSERT into SQL with a format file (.fmt).
The format file uses "\r\n" to find the end of each line so the CrLf has to be in the same place at the end of each line.
I need a batch file to count the columns and insert spaces for the shorter lines.

Truncate or Pad Each Line In Text File using a DOS Batch File

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.