Tricky one. DTS and Strip Tags from csv file
From: Joey D (joey_at_ultraweaver.com)
Date: 08/25/04
- Next message: Daniel B: "Can't schedule Application using DTS"
- Previous message: Sean: "Bulk Insert - How to represent nulls in .txt input file?"
- Next in thread: Jacco Schalkwijk: "Re: Tricky one. DTS and Strip Tags from csv file"
- Reply: Jacco Schalkwijk: "Re: Tricky one. DTS and Strip Tags from csv file"
- Reply: Bill D: "Re: Just do it with VBS transform. DTS and Strip Tags from csv file"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Aug 2004 11:36:59 -0500
At least it is tricky for me. I am using DTS to import a csv file daily into
a table. The only problem is that the csv file that is sent contains a bit
of HTML at the beginning and end of the file.
Example CVS file:
Complete!<br><PRE>123, fish, paste
321, krabby, patty
987, conch, shell<PRE>
I am not sure what I need to do to remove the characters
"Complete!<br><PRE>" at the beginning of the first record and the "<PRE>" at
the end of the last record.
The file is generated and sent automatically. There is no way to get the
file delivered without the unwanted HTML. I can manually remove these tags
but this will be a daily thing and needs to be automated. Any ideas on how
to get rid of the unwanted tags? I am a newbie to SQL let alone DTS. Been
trying to get this worked out for a few days now.
Any help is greatly appreciated.
-- Joey Durham www.ultraweaver.com - Tutorials/Downloads
- Next message: Daniel B: "Can't schedule Application using DTS"
- Previous message: Sean: "Bulk Insert - How to represent nulls in .txt input file?"
- Next in thread: Jacco Schalkwijk: "Re: Tricky one. DTS and Strip Tags from csv file"
- Reply: Jacco Schalkwijk: "Re: Tricky one. DTS and Strip Tags from csv file"
- Reply: Bill D: "Re: Just do it with VBS transform. DTS and Strip Tags from csv file"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
