[AccessD] Zero-width characters in query

[Stuart McLachlan]

You are correct. 

I've seen tabs and all all sorts of  other bad things from people copy/pasting from Word into 
Access (smart quotes are a real PITA).



On 26 May 2017 at 15:57, Bill Benson wrote:

> When the user has copied and pasted the data from a source in Word or
> another program, into a field in Access, I believe tabs go in as
> CHR(9) without the user having to physically touch the tab key
> themselves. But Maybe I am imagining this memory.
> 
> On Fri, May 26, 2017 at 3:16 PM, Charlotte Foust
> <charlotte.foust at gmail.com> wrote:
> 
> > I was assured that the values were typed in, but I don't know of any
> > way to type a tab into a text box when tab is the default action for
> > moving to the next control.
> >
> > Charlotte Foust
> > (916) 206-4336
> >
> > On Thu, May 25, 2017 at 1:26 PM, Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > Someone must have imported a badly structured text file into the
> > > database :(
> > >
> > >
> > > On 25 May 2017 at 8:20, Charlotte Foust wrote:
> > >
> > > > I tried that, but the first character wasn't null, it was a
> > > > chr(9).  I replaced it with a null string to cure the craziness.
> > > >
> > > > Charlotte Foust
> > > > 916-206-4336
> > > >
> > > > On May 25, 2017 7:56 AM, "Rocky Smolin" <rockysmolin at bchacc.com>
> > > > wrote:
> > > >
> > > > > Not a solution but if you retrieved the second character in
> > > > > the string in the event that the fist character was blank or
> > > > > null, would that second character actually be the first
> > > > > character in the string?
> > > > >  Or be the second character?
> > > > >
> > > > > Rocky
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > > > > Behalf Of Charlotte Foust Sent: Wednesday, May 24, 2017 10:49
> > > > > PM To: Access Developers discussion and problem Subject:
> > > > > [AccessD] Zero-width characters in query
> > > > >
> > > > > I ran into something today that left me scratching my head.  I
> > > > > ran a query to extract the first letter of a company name to
> > > > > use as an index.  About 42 out of some 60k came back empty and
> > > > > no editing I could do would change that.
> > > > >
> > > > > I hunted around the internet and found a few issues with
> > > > > SharePoint and Unicode but nothing that made sense in context.
> > > > >  Have any of you ever happened on this?  I found a way to fix
> > > > > the fields, because i could find no way to query around it. 
> > > > > The length of the string was for the visible characters, but
> > > > > the first character wasn't visible.
> > > > >
> > > > > Charlotte Foust
> > > > > 916-206-4336
> > > > > --
> > > > > 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
>