[AccessD] Import Large delimited file with special character s

Search for two of them together and replace them with one.  That will
clear out any extras.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Wednesday, July 19, 2006 8:25 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Import Large delimited file with special
character s

Thanks Marty...but not all of the CR and LF need to be replaced.  There
still needs to be one at the end of each line.




>From: MartyConnelly <martyconnelly at shaw.ca>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Import Large delimited file with special
character s
>Date: Tue, 18 Jul 2006 15:25:46 -0700
>
>   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
>
>--
>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