Skip rows where the first column with letter 'S' - BCP

Giganews Newsgroups
Subject: Skip rows where the first column with letter 'S' - BCP
Posted by:  ntuyen…@yahoo.com
Date: 9 Aug 2006

Hi All,
I have this data file with fix length(see below). I am able to insert
it into the database using bcp, but now I want to skip (do not insert)
the row which start with letter 'S' into the database. Is there away to
do it? By the way I am using -F2 option to skip the first record.

Here is my data:
Record 1 04
                                      XXX
2 13106900240120042003040045061            Testing N POLYDOROS TRUST
EEE
2 12621241640280041004040045633            What are they MARTIN &
      XXXXX
S C10000032004004098500000596110000005000010000000019613000000576497500
S X10000032000002098500000596130000000000000000000019613000000573497000

Thanks for your help.

Ted Lee

Replies