Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove Quotes from Text file before Import

Status
Not open for further replies.

niall29

Technical User
May 1, 2003
38
GB
Hi again,
I am not sure if I am in the right forum this time so please be patient with me.
I have a text file which is sent to me every day with roughly about 70 columns and about 300,000 rows which has columns delimited by commas and Text by quotations and Rows by LF.
and I run a DTS to import the file into a table everyday before I get to work, but it has crashed a few times and today I investigated why (I was getting an error saying "Column Delimiter not found") when I looked at the record where the problem was I noticed that if the street was only one letter the file which was sent to me has quotations aroun it to show it is supposed to be like that, but this is causing me havoc as my DTS thinks it is a Text field and is looking for a comma after the quotes close and hence "Column Delimiter not found" I hought of building a Replace statement into my DTS in VBscript but that is not helping I need to remove the quotes before I start the import.

PLEASEEEEEEEE can someone help. I am totally lost with this one.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top