<div>
not sure which of the lines of code result in that line, and if nothing helps, you rework the file with another cat + find &gt;&nbsp;newfile to skip that line ...
</div>


not sure which of the lines of code result in that line, and if nothing helps, you rework the file with another cat + find > newfile to skip that line ...

<div>
@oBdA: You are champion 500+
</div>


<div>
<div class="content wysiwyg-content">
<b><br />
&nbsp;Batch File code<br />
<br />
</b><br />
<br />

<pre><code id="code-10-28006830-1">@echo off
SETLOCAL ENABLEDELAYEDEXPANSION


bcp &quot;select 'Name', 'EIN', 'AccountId', 'Other ID', 'Address Line 1', 'Address Line 2', 'City', 'State', 'Zip Code', 'Country', 'Other Data', 'Provider ID', 'Group ID' union all select * from testdb&quot; queryout &quot;C:\Data\CAAGBusinessFile.txt&quot; -c -test\T_GSS -testuser -mypass

call :StripBlankLines CAAGBusinessFile.txt


bcp testdb out &quot;C:\Data\CAAGIndividualsFile.TXT&quot; -c -SNTSMSQL15011A\T_GSS -tesur -Ptest




call :StripBlankLines CAAGIndividualsFile.TXT


:StripBlankLines

For %%x in (%*) do set OutF=temp_(%%~nx).txt

::del %OutF%


for /F &quot;tokens=* delims=&quot; %%B in (%*) do echo %%B &gt;&gt; %OutF%

Goto :EOF

:End</code></pre>
<br />
<b> Output </b><br />

<pre><code id="code-10-28006830-2">kiran	G	Sonawane		12	1	1	Rahatani		Pune	MH	41125	IN		O	1	1 
ECHO is off
test				233												 
Prakash	S	Tike		33	2	2	Don		K		456					1 </code></pre>
</div>
</div>



 Batch File code



(CODE)

 Output 
(CODE)

Batch file Remove &quot;ECHO is off &quot; from output 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

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

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.

Batch file Remove &quot;ECHO is off &quot; from output file

Batch file Remove "ECHO is off " from output file