Posted by ntuyen01 on 08/09/06 15:16

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

• Next in forum: Get files in different folder using sql
• Prev in forum: SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
• Thread view: Skip rows where the first column with letter 'S' - BCP

[Reply to this message]