MartyConnelly
martyconnelly at shaw.ca
Tue Jul 18 17:25:46 CDT 2006
strAddress =Replace (strAddress, Chr(13) & Chr(10), "") or if you want a space strAddress =Replace (strAddress, Chr(13) & Chr(10), " ") Mark A Matte wrote: >Thanks Drew, > >....but the issue would be 'How do you tell the right from the wrong? > >Thanks, > >Mark > > > > >>From: DWUTKA at marlow.com >>Reply-To: Access Developers discussion and problem >>solving<accessd at databaseadvisors.com> >>To: accessd at databaseadvisors.com >>Subject: Re: [AccessD] Import Large delimited file with special character s >>Date: Tue, 18 Jul 2006 16:09:36 -0500 >> >>The Replace() function?? >> >>Drew >> >>-----Original Message----- >>From: Mark A Matte [mailto:markamatte at hotmail.com] >>Sent: Tuesday, July 18, 2006 3:59 PM >>To: accessd at databaseadvisors.com >>Subject: [AccessD] Import Large delimited file with special characters >> >>Hello All, >> >>I've been back and forth with this issue. I think some here helped me with >>this years ago. Importing a large delimited text file...that has a >>text/memo/blob field. I'm running into CR or LF in the blob. Is there a >>way to remove these characters...I seem to remember someone telling a way >>to >> >>loop through and replace these characters...but I can't find it. >> >>Any have ideas? >> >>Thanks, >> >>Mark >> >> >>-- >>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 >> >> > > > > -- Marty Connelly Victoria, B.C. Canada