Re: How do I remove the last line (Trailer line) in a file.

#1

The easiest way and I have used this at a client is to call the UNIX utility
from the cmdline and have it generate another file for you to use - trailer.
Short of that I do not think Windows has an equivalent so you would need to
read the rows in (FSO) and write them back out to another file.

Not nice on a big file.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"Narendra" <Narendra (AT) discussions (DOT) microsoft.com> wrote

Quote:

Every morning we receive .csv files from a vendor and we need to remove
the last line which gives information like how many records in the file etc.

What is the easiest way to do it. The last line will always be in the
following format - TRAILER,#of records

Quote:

In unix there is a command called grep that does similar things, what is
the equivalent of this in Windows or for that matter how to do it.

I need to bcp in this data into our database. Thanks in advance for the
help.

#2

In message <1C10757E-D3FF-4E49-866A-DD6BADC80F3A (AT) microsoft (DOT) com>,
Narendra <Narendra (AT) discussions (DOT) microsoft.com> writes

Quote:

Every morning we receive .csv files from a vendor and we need to remove
the last line which gives information like how many records in the file
etc. What is the easiest way to do it. The last line will always be in
the following format - TRAILER,#of records

In unix there is a command called grep that does similar things, what
is the equivalent of this in Windows or for that matter how to do it.

I need to bcp in this data into our database. Thanks in advance for the help.

GNU do unix utilities that run on Windows
(http://www.gnu.org/software/grep/), but plenty of others out there as
well, just do a quick search.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How do I remove the last line (Trailer line) in a file.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: How do I remove the last line (Trailer line) in a file. - 08-04-2004 , 02:24 PM

Re: How do I remove the last line (Trailer line) in a file. - 08-04-2004 , 03:48 PM