Hi all (and with thanks to those who offered me solutions for my recent
ASCII question which I haven't had time to sort out yet) I'd like to
pose the far simpler question:

How can I persuade FileMaker (in a script) to differentiate between 'a'
and 'A'?

e.g.

Case ( field = "a" ; "that's a lower case a" ; field = "A" ; "that's a
capital A" ; "that's neither" )

FileMaker (8.0v1) does this:

"a" gets "that's a lower case a"
and
"A" gets "that's a lower case a"
whereas
"b" gets "that's neither"

I'm sure there must be a way ... and it doesn't seem much to ask!


Emma

Emma Grey <gone (AT) way (DOT) far> wrote:
There is a function for that: Exact ()

BTW ã and ä and à are also considered A's

In article <46614182$0$299$dbd4d001 (AT) news (DOT) wanadoo.nl>, Sargasso
<no.way (AT) ho (DOT) se> wrote:


Yes, I did come across that funtion, but it seemed to be about
COMPARING two sets of text. Could I ask how would I use it to modify
this below so it works?

A script for a calculation field that converts into ASCII numbers

Case (inputfield = "a" ; "097" ; inputfield = "A" ; "065" ; "n/a")

Sorry if I'm being dense; maybe I should buy that "Missing Manual"
book. I used to work with FileMaker extensively some years ago, and
could get it to do anything I wanted - but that was v.5.

These days it leaves me way behind.

Thanks for your patience.

Emma

Case (
exact("a"; field); "that's a lower case a" ;
exact("A"; field); "that's a capital A" ;
"that's neither" )


Emma Grey wrote:

Emma Grey <gone (AT) way (DOT) far> wrote:
Case ( Exact ( inputfield ; "a" ) ; "097" ; Exact ( inputfield ; "A" ) ; "065"
; "n/a" )

In article <4661aa1e$0$5478$dbd4f001 (AT) news (DOT) wanadoo.nl>, Sargasso
<no.way (AT) ho (DOT) se> wrote:

Excellent, thanks Sargasso

Emma

In article <136393bbq2hjl61 (AT) corp (DOT) supernews.com>, Howard Schlossberg
<howard (AT) nospam (DOT) fmprosolutions.com> wrote:

Aaah! thanks Howard for helping me out here.

Emma