MartyConnelly
martyconnelly at shaw.ca
Wed Jul 19 13:34:16 CDT 2006
I don't know what generated the original text but I am just wondering if you have a mixture of hard and soft carriage returns. This is just a stab in the dark A hard return vbcrlf is like a word paragraph mark. to enter via Access on a form you press Ctrl Enter, A soft return would appear as a black rectangle when displayed on a form in a memo field. you might want to check if you have vbCrLf = chr(13)+ chr(10) or vbCr = chr(13) UPDATE tblMemo SET tblMemo.TestMemo = Replace ([TestMemo],Chr(13) & Chr(10),"***"); then UPDATE tblMemo SET tblMemo.TestMemo = Replace ([TestMemo],Chr(13),"$$$"); Mark A Matte wrote: >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 >> >> > > > > -- Marty Connelly Victoria, B.C. Canada