Can filemaker differentiate a different case?

Hi

I am new to filemaker pro and trying just starting to create fields in
a database.
My raw data referes to a dimension on a drawing on one side its 'd'
and the other its 'D'. Is there a way filemaker can tell the
difference between d and D or do I need to re-label one of them
something completly different?

Martin

Re: Can filemaker differentiate a different case?

On 2007-11-06 07:31:33 -0800, "martin.a.john@gmail.com"
said:

> Hi
>
> I am new to filemaker pro and trying just starting to create fields in
> a database.
> My raw data referes to a dimension on a drawing on one side its 'd'
> and the other its 'D'. Is there a way filemaker can tell the
> difference between d and D or do I need to re-label one of them
> something completly different?
>
> Martin

You can construct a test calculation using the Position, Patterncount
and Exact strings to determine if a particular character is upper or
lower case.

View the online help about each of those functions to learn the syntax
you need.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

Re: Can filemaker differentiate a different case?

"Lynn Allen" wrote in message
news:4730a519@news.bnb-lp.com...
> On 2007-11-06 07:31:33 -0800, "martin.a.john@gmail.com"
> said:
>
>> Hi
>>
>> I am new to filemaker pro and trying just starting to create fields in
>> a database.
>> My raw data referes to a dimension on a drawing on one side its 'd'
>> and the other its 'D'. Is there a way filemaker can tell the
>> difference between d and D or do I need to re-label one of them
>> something completly different?
>>
>> Martin

Lynn Allen wrote:

> You can construct a test calculation using the Position, Patterncount and
> Exact strings to determine if a particular character is upper or lower
> case.

Also... Exact returns true or false (1 or 0) if two strings are/aren't
identical. It will tell you that one field =D or =d only if you know that
the other =D or =d. Otherwise it will only tell you that one is not= to the
other but not tell you why.
To determine what's what you can use a combination of Exact and the Upper or
Lower function like this:

Exact ( Text; Upper ( Text ) )
This calculation will return true if the contents of field "Text" is all
upper case.

Exact ( Text; Lower ( Text ) )
This calculation will return true if the contents of field "Text" is all
lower case.

If you need to test elements in a string combine with Position, Patterncount
as Lynn suggested.

Re: Can filemaker differentiate a different case?

On Nov 6, 9:32 am, Lynn Allen wrote:
> On 2007-11-06 07:31:33 -0800, "martin.a.j...@gmail.com"
> said:
>
> > Hi
>
> > I am new to filemaker pro and trying just starting to create fields in
> > a database.
> > My raw data referes to a dimension on a drawing on one side its 'd'
> > and the other its 'D'. Is there a way filemaker can tell the
> > difference between d and D or do I need to re-label one of them
> > something completly different?
>
> > Martin
>
> You can construct a test calculation using the Position, Patterncount
> and Exact strings to determine if a particular character is upper or
> lower case.
>
> View the online help about each of those functions to learn the syntax
> you need.

If he is trying to differentiate between the two cases within a string
of text, then the functions you mention are relevant.

If he is refering to field names, then no, filemaker is not case
sensitive. One cannot have a field 'd' and a field 'D'. At least one
will need to be relabeled. (d_small, and d_big, or whatever...)

(As an aside, it is generally considered poor practice to define case
sensitive field names although some databases do allow it.)

-cheers,
Dave

Re: Can filemaker differentiate a different case?

On 2007-11-06 23:30:39 -0800, d-42 said:

> If he is refering to field names, then no, filemaker is not case
> sensitive. One cannot have a field 'd' and a field 'D'. At least one
> will need to be relabeled. (d_small, and d_big, or whatever...)
>
> (As an aside, it is generally considered poor practice to define case
> sensitive field names although some databases do allow it.)

Good point. The original post is ambiguous.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA

Re: Can filemaker differentiate a different case?

Sorry for the ambiguity.

I was looking at naming the field names upper and lower case.
I have used an underscore to differentiate i.e. "d" and "D_"

Thanks for the help