Find Large, finds X-Large

[RodM]

I have a Find command with 2 set comannd

looking for word 'Large'

however it counting 'X-Large'

Dose this have to do with the - char

I have set my Find to ==

Then I get a 0 foundcout?

Code image attached

Thank

[efen]

You are first setting search criteria by the set fields then changing it to search for just "==" with [restore]

[RodM]

At first I only used the 2 set fields ( didn't work?),

afterwards trying the ==

Restore? I am not clear on this meaning..

Seems like Finds will find the Large in X-Large is the problem?

[lawaid]

Hi Rod:

... because the string "large" can be found in the string "x-large"

efen's suggestion of using "==x-large" as the search criteria forces FM to find entries matching your exact request.

[RodM]

Just getting back...I don't get it! feel real stupid again

It seems your saying... do not use the 2 set field commands before the Find command?

makes no sense... And when I open the find command its surely weird and limiting. AND using some modifier in the Find command, makes it a Restore... by default..

I can not use ==X-large I must use ==$$manualPick a parameter being passed

..and it pops me out not taking it.

That's another strange thing... inside the Find, only seems to allow picking from the table fields not using my $$vars

[mr_vodka]

When you restore the find, it doesnt matter what you have in your set field steps while in find mode. It will just restore the specific find criteria that is specified.

Modify your set Field:

Set Field [ Pkg_InvNo; $tmpInvNo ]

Set Field [ Pkg_Size; "==" & $tmpNameItem ]

Perform Find [] // No Restore

[RodM]

Set Field [ Pkg_Size; [color:red]"==" & $tmpNameItem ]

Great example was really all i needed...didn't know how that was done.. thanks'

[RodM]

Your last example in my Find with "==" worked fine as per example above, Now i am trying to use same principle "the not equal" opposite of =

Lookat at the snippet of code for my Find

Foundcount = 0

I have this 1 record in my inventory that has blank field or is not "Yes"

Can you help me again please

[mr_vodka]

Set Field [ InvNo; $tmpSameAcct ]

New Request

Set Field [ LabelInAccumulator; $test ]

Omit Record

Perform Find

[RodM]

feeling stupid, I think i need some Volka... thank you Sir

I can't find 'New ReQuest' here i am using ver 9 looking down all the commands..

..so I get, we find all records that "Yes", omitting them, whats left over is my "other records". FM is strange..

[mr_vodka]

Sorry the exact script step is: New Record / Request

This adds a new request criteria.

To help you out, I suggest thinking about how the find wound be manually. Then your script steps would make sense.