[AccessD] Delimiter Value

[John W. Colby]

I found the tab symbol was quite often intentionally inserted by folks 
when typing in their address.  The third party software I use for 
address validation just copies the address you give them and hands it 
back to you if there has been no change.  Thus whatever the user typed 
in, I send to them, and they (usually) send back to me. Tabs wreaked 
havoc in my files.  I have never had a problem since switching to pipes.

On a similar note, I also had problems with the double quote, where 
people would quote a nickname - John "jack" Doe.  The extra quotes 
wreaked havoc with the CSV file use of quotes as the delimiter package.

John W. Colby

On 3/3/2015 11:01 AM, Tina Norris Fields wrote:
> This is an intriguing part of the discussion.  One perspective is to 
> find a symbol that will not accidentally be typed because it's not on 
> a standard keyboard.  The other perspective is to find a symbol that 
> can easily be used (because it is on a standard keyboard), but is not 
> commonly used for most typing and coding. Fascinating.  I like the 
> pipe symbol because it fits with the second perspective.  I would like 
> an ALT+ASCII code symbol that is easy to remember and doesn't appear 
> on a standard keyboard, too, because it reduces the threat of 
> accidental typing.  Hmmm - pondering.
> TNF
>
> Tina Norris Fields
> tinanfields-at-torchlake-dot-com
> 231-322-2787
>
> On 3/3/2015 8:13 AM, Jim Dettman wrote:
>>
>>   I'm not sure if it's as true today as it once was, but using anything
>> beyond 127 was iffy.
>>
>>   The extended characters have no set definition unlike those below 
>> 128.  So
>> while that may not exist as a character on a US keyboard, it may 
>> exist on
>> others because it might not be a cent symbol.
>>
>>   I use the vertical pipe as well because to my knowledge, there's no 
>> place
>> where one would use it outside of computer commands and it is easy to 
>> read
>> because the character is thin.
>>
>> Jim.