Hello Group Members,
The Equation Editor toolbar has two arithmetical operators ~ = and ==
= is to be used in a criteria (expression) when looking for a Character Field beginning with.
== is to be used in a criteria (expression) when looking for an exact match on the Character Field.
Let us understand this post with an example.
You have a file with field 'Item Description'. Some of the sample 'Item Description' are ~
Bearing 85 - 120Z
Bearing 95/zzz
Bearing Large
Shaft 9mm
Now if your requirement is to examine records where the 'Item Description' begins with Bearing then your criteria in the Equation Editor will be -
Item_Description = "Bearing"
On the other hand if you are looking to extract records where the 'Item Description' exactly equals to Bearing Large then your criteria in the Equation Editor will be -
Item_Description == "Bearing Large"
Best Regards
Group Admin Team