Names with F or L

[sicSRT8]

I am using this calculation and want it to find

Calc= name_id & "F"

How would I write it to find name_id & "f".... OR R in the same calc.

[Ocean West]

If your in a script..

Enter Find Mode

Set Field: your field [ name_id & "f"]

New Request

Set Field: your field - name_id & "r"

Perform Find

This creates an OR find

[sicSRT8]

no its a calc field. I need "F" and or "L"

[LaRetta]

I might suggest you instead drop the calc field and keep the two pieces of information separate (the NameID is already separate anyway). Why not have a field which holds the suffix? As it is, you create a calculation to concatenate the data, then want to pull it apart again (so to speak). And it seems that the suffix indicates something special to you (or you wouldn't need to then find the information again separately). Keeping the pieces apart makes it easier to handle.

Then you can just search that suffix field for F, new record/request and L (or R as you originally called it).

UPDATE: Otherwise, you can search for *r ... but if your NameID happens to have characters, it can find false positives.

Edited October 9, 2009 by Guest
Added update

[Lee Smith]

It is confusing as to what you want the find to be, as you describe it as two fields, and an OR request.

Calc= name_id [color:blue]& "F"

find name_id [color:blue]& "f".... OR R in the same calc

I need "F" and or "L"

If there is one field for name_id, and a second field that contains the F, f, L or R,

You can find on the two fields as suggested by Ocean West

However, if you are searching for the F, f, L or R in the field of name_id,

then you would

enter find mode

type in F in name_id

[color:blue]New Record Request

type in f in name_id

[color:blue]New Record Request

type in L in name_id

[color:blue]New Record Request

type in R in name_id

This will find any record with the F, f, L, or R in the name_id field.

Read about AND and OR finds in your Online Help, or User Guide.

HTH

Lee

[sicSRT8]

Inside my calculation I have

cName=state_id & "F"

How can I write to include the letter R to that calculation. Its not a script its a calc field.

cName=state_id & "F" [color:red]& or "L"

i use this field as part of a combined relationship the single out the names with F in them. I also want to include names with L. This is the field that does that but not sure how to add the letter L to the calculation statement

[comment]

I am not sure I follow this either, but I guess you want =

cName = state_id & "F" or cName = state_id & "L"

Hopefully, this is happening in a another calculation field, not in cName…

[sicSRT8]

I am trying to use both letters F and L in one calculation.

I need it to find both in the same occurrence. I am not using a script it is found in the cName field under calculation. It serves a purpose but can figure out how to get them both in the same calculation and work.

[grumbachr]

I'm a bit lost too but what about ="F" & ¶ & "L"

[sicSRT8]

That didnt work for me.

Basically I have a field that uses a drop down list based of the cName field. So all names with F currently show up in list. But I want to change the calc to include names with L... So the list will have all names with F and with L...

To determine the names cName is the field that figure this out. But I don't know how write the calculation

cName=name & "F" and "L"?

cName=name & "F,L"?

CName=name & "F & L"?

[grumbachr]

to try my suggestion you need

cName=name & ¶ & "F" & ¶ & "L"

its a multi-key value. you need to include the paragraph symbol (thats what I call it at least).

search on these boards for multikey or multi-key

[sicSRT8]

I get a response when I use the original "F" calculation but when I try anything to add the L including the last suggestion I get nothing. Should I be using brackets or something this shouldnt be that difficult its just another letter.

[LaRetta]

It serves a purpose but can figure out how to get them both in the same calculation and work.

Well, we are playing guessing games because you simply don't give us enough information. We do not know how you are USING this calculation; in fact, you didn't answer Comment's question nor have you given us any help in helping you. But let's try one more time then ...

Using your original calculation of: name_id & "F" ... which you say works ...

Try:

name_id & "F" & ¶ & name_id & "L"

This will work if you are using this field as match field in a relationship but we don't know what you are using it for anyway. If this isn't it, provide more information this time. :wink2:

Edited October 13, 2009 by Guest

[grumbachr]

Sorry I wasn't more helpful best I could do on what we've been given. Most of the people posting here are way smarter than me when it comes to filemaker and you have their attention. I recommend giving them as much detail as possible and they will help resolve your problem.

[sicSRT8]

Laretta yours worked like a champ!

Im sorry if I didnt provide enough info I thought I was... Thanks everyone for your help and the ¶ explanation. There is no way I would have figured this out with this forum...