[AccessD] FW: Removing quotes

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Jun 1 08:10:19 CDT 2007


Erwin:

Thanks.  I'll take a look.

Regards,

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT
Helps
Sent: Friday, June 01, 2007 5:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] FW: Removing quotes

I have written a long time ago some little vb app to remove some strings
from files in a folder.
At that day someone needed to strip HTML code from a lot htm files.

It only removes charachters not replace them.

www.ithelps.eu/tools


I noticed that the tool is regulary downloaded so is upose it has his use
:-)

Erwin



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Friday, June 01, 2007 12:36 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] FW: Removing quotes

Dear List:
 
A client has a large tab delimited file which I'm trying to import into an
access table using the wizard.  The text fields in the tab delimited file
have quotes around them.  Unfortunately the Description field has embedded
quotes for descriptions with lengths - i.e. "Suture 3 1/2" ".  
 
So if I import with the quote as text qualifier any record with a quote in
the description field is unparseable because there's an uneven number of
quotes and all of the subsequence fields after the Description are dropped.

If I import with no character as the text qualifier I get all the fields but
all the text fields are surrounded by quotes.  So I have to remove them. 
 
I'm thinking to do it with a couple update queries but there are about 140
fields so it would be awkward and a bit time consuming to structure and test
the update queries.  
 
I'm thinking of doing it with a bit of code - cycle through the fields for
each record and strip the quotes (also replace the quote that represents
inches with 'in.')
 
I think it would take an hour to do it in code. But is there any faster,
easier, slicker way I'm overlooking?
 
MTIA
 
Rocky

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.5/826 - Release Date: 5/31/2007
4:51 PM
 




More information about the AccessD mailing list