[AccessD] tabs in memo fields

You know there is an instrrev function to find the LAST instance of a
character (or str)?  It starts the search from the end of the string and
works toward the front.

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Wednesday, January 05, 2005 9:20 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] tabs in memo fields


Hi Roz:

Thanks for your help. I have been playing with tracking the tabs (chr(9))
with 'instr' but have been having some issues handling the fields through a
function as the memo content is so large. 

Thanks again for your help.
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Roz Clarke
Sent: Wednesday, January 05, 2005 1:23 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] tabs in memo fields

Hi Jim

I hope some bright spark who actually slept last night will come up with an
elegant solution because the only thing I can come up with at the moment is
rather clunky.

Do an INSTR to find the first tab character (CHR(9) iirc). Keep doing this
on the same memo until you don't find a tab, then move on to the mext memo.
You could use a flag to indicate whether a tab was found on the last pass or
not, so that your code knows whether to look at the same memo again or move
on to the next one.

Untested, ungraceful... if there's a neat way of doing it I'd like to know
too

Roz

-----Original Message-----
From: Jim Lawrence [mailto:accessd at shaw.ca] 
Sent: 05 January 2005 07:52
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] tabs in memo fields


Hi All:

It seems simple but, is there a way to replace tab characters within a memo
field using a query or function? Note, memo field can be many hundreds of
characters.

TIA
Jim

-- 
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