[AccessD] how do I remove CRL from text (field)?

Jim Dettman jimdettman at verizon.net
Tue Aug 14 15:13:09 CDT 2012


 and on that point, there is also vblf and vbcr if you need (or want) to
deal with them separately.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Tuesday, August 14, 2012 10:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] how do I remove CRL from text (field)?

This is a minor point, but it's caught me before - the VB constant
vbcrlf is actually two characters - a carriage return chr(13) and a
line feed chr(10).  But the Replace code mentioned here works fine.

Doug

On Tue, Aug 14, 2012 at 7:15 AM, jack drawbridge <jackandpat.d at gmail.com>
wrote:
> Thanks Lambert. You only have to do the replace with "" once to realize
> there may be a different context. Replacing vbcrlf with space is easier
> than changing  strHorriblyLongText back to  "space separated words".
>
> On Tue, Aug 14, 2012 at 9:48 AM, Heenan, Lambert <
> Lambert.Heenan at chartisinsurance.com> wrote:
>
>> Good point Jack. :-)
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com [mailto:
>> accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge
>> Sent: Tuesday, August 14, 2012 9:20 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] how do I remove CRL from text (field)?
>>
>> If you are removing CrLf, you MAY want to repalce each with a single
space.
>> Especially if you are removing CrLf from long text and wish to keep a
long
>> text of "words".
>>  Slight mod to Lambert's code
>> strVariable = Replace(strVariable,vbCrLf," ")
>>
>> Just trying to guess the context--- I think we've all done this at some
>> time or another.
>>
>> jack
>>
>> On Tue, Aug 14, 2012 at 9:01 AM, Heenan, Lambert <
>> Lambert.Heenan at chartisinsurance.com> wrote:
>>
>> > strVariable = Replace(strVariable,vbCrLf,"")
>> >
>> > That should do it.
>> >
>> > Lambert
>> >
>> > -----Original Message-----
>> > From: accessd-bounces at databaseadvisors.com [mailto:
>> > accessd-bounces at databaseadvisors.com] On Behalf Of Garraway, Alun
>> > Sent: Tuesday, August 14, 2012 8:34 AM
>> > To: Access Developers discussion and problem solving
>> > Subject: [AccessD] how do I remove CRL from text (field)?
>> >
>> > Hallo,
>> >
>> > who can I remove CRL (carriage return linefeed) from text (field)??
>> >
>> > Either with in built functions or VBA............
>> >
>> > Any tips would be really appreciated :-)
>> >
>> > alun
>> > --
>> > 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
>> >
>> --
>> 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
>>
> --
> 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



More information about the AccessD mailing list