[AccessD] Delimiter Value (was: Automatic Update Function)

[Dan Waters]

Hi John,

A pretty safe delimiter is a ¢ symbol (cent symbol).  To use it, you'll have
to find it somewhere and copy it into your code.  Or, you can could also use
Chr(162).

I don't think a cent symbol is on any US electronic keyboards, and certainly
not on any others.

I found a good list of Chr values at
http://www.gtwiki.org/mwiki/?title=VB_Chr_Values.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Monday, March 02, 2015 15:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automatic Update Function

Of course it was simple.  However if you look at SQL Server export for
example, by default if you tell it to use quotes, it quotes EVERY FIELD.

So if you are getting data from the wild, look out.  If you are doing the
export yourself, and then the import yourself, it is really fairly easy, you
control both ends.

As I mentioned I like pipe delimited because (in MY data) pipes are unheard
of, so using that as a delimiter is pretty safe.  My data is name / address
from the wild, so tabs are encountered occasionally. I have never actually
seen a pipe coming in from raw data, though of course it is a key on the
keyboard and someone could accidentally hit it.

John W. Colby