CUSTODIAN-L Archives

Archiver > CUSTODIAN > 2002-01 > 1010677076


From: "Clive Challis" <>
Subject: Re: [CUST] X's in Note field/Clive
Date: Thu, 10 Jan 2002 15:37:56 -0000
References: <d8.11c2d2e7.296ef2b9@aol.com>


Hello Sonja,

Many thanks - worked a treat.

Clive


----- Original Message -----
From: <>
To: <>
Sent: Thursday, January 10, 2002 1:35 PM
Subject: [CUST] X's in Note field/Clive


> Hello Clive
> Some time ago you asked about removing the x which appeared in the Note
field
> after import, even when a note is not entered.
> In case you haven't resolved it, this is what to do:
> In the data-entry form, use the Multiple Update function in the Edit menu
as
> follows -
> Update xxxxxx Set Flag = "" Where NOTES = ""
> (where xxxxxx is the table name already inserted for you)
> Then choose Run.
> If there is an unseen character in your Notes field, such as a space,
which
> is causing the problem, you can use the following -
> Update xxxxxx Set Flag = "" Where NOTES = " "
> Hope this helps.
> Regards
> Sonja
>
>
>
> ==============================
> To join Ancestry.com and access our 1.2 billion online genealogy records,
go to:
> http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237
>

This thread: