How to allow "@" in text field?

In my local community, many have their name with the character "@",
e.g. Chong YuYi @ Elaine. How do I allow this character as a normal
text so that I can type and serach?

Re: How to allow "@" in text field?

Han Wei

You can type it normally then search with "" around the words.

go into find mode and type "Chong YuYi @ Elaine"

perform the search and you will find Chong YuYi @ Elaine

You could also work around it, using your own code (like an $) when you type
it AND when you search it. But use a calculation to replace the $ with @ for
displaying and printing.

Keep well, Ursus

"HanWei" schreef in bericht
news:a32b7adb-8336-40ae-a509-55b27a9d5d7e@l32g2000hse.google groups.com...
> In my local community, many have their name with the character "@",
> e.g. Chong YuYi @ Elaine. How do I allow this character as a normal
> text so that I can type and serach?

Re: How to allow "@" in text field?

Say the field 'Name' contents is "Chong YuYi @ Elaine". Then you may create
a calc field "Name2"= Substitute ( Name ; "@" ; "ZZZ" ). Then have 2 global
fields 'gName1' - used to search the name - and 'gName2' plus a button that
launches a script that looks like (pseudo code) ::
Set Field (gName2; Substitute ( gName1 ; "@" ; "ZZZ")
Enter Find Mode
Set Field (Name2; gName2)
Perform Find/Replace
You can make those steps transparent to the user, by showing only the found
'Name'.
Remi-Noel

"HanWei" a écrit dans le message de
news:a32b7adb-8336-40ae-a509-55b27a9d5d7e@l32g2000hse.google groups.com...
> In my local community, many have their name with the character "@",
> e.g. Chong YuYi @ Elaine. How do I allow this character as a normal
> text so that I can type and serach?

Re: How to allow "@" in text field?

HanWei writes:

> In my local community, many have their name with the character "@",
> e.g. Chong YuYi @ Elaine. How do I allow this character as a normal
> text so that I can type and serach?

In search mode @ has a special meaning and has to be escaped with \@:

YuYi \@ Elaine

-jens

--
http://jensteich.de

Re: How to allow "@" in text field?

In article
,
HanWei wrote:

> In my local community, many have their name with the character "@",
> e.g. Chong YuYi @ Elaine. How do I allow this character as a normal
> text so that I can type and serach?

You don't need to search for EVERYthing typed into a Text field - this
is a novice mistake. In your case you can leave out the @ symbol when
performing a search and FileMaker will still find the correct record.

For example, if you have a database with records that have the
following in a Text field:

Chong YuYi @ Elaine
Chong YuYi @ Elmo
Chong YuYi @ George
Chong YuYi @ Wilma
Fred Fintstone @ Freddyboy
Quickdraw McGraw @ ElKabong

and you perform a search just using:

Chong YuYi Elaine

or using:

Chong Elaine

or even just using:

Ch Yu Ela

then FileMaker will find only the first record above (the Chong YuYi @
Elaine record).

If you perform a search with just:

Chong YuYi

or using:

Cho Yu

then FileMaker will find the first four of the example records above.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)