The Technique to apply 'Does Not Contain' in IDEA

There are two methods in IDEA to look for a character string in an all character and / or alpha - numeric field.

 

Let us say you have a narration field in a Ledger data file on which you would like to look for narration contains the character string ~ gift.

 

One way to achieve the same is through a Direct Extraction using the criteria @isini("gift", Narration). This will look for the character string ~ gift in the field Narration irrespective of the Case (i.e. Upper / Lower / Sentence Case).

 

The other way to achieve the expected outcome is to enter *gift* in the Text to Find box in Search under Data in the IDEA menu tool-bar and to look for *gift* in the field Narration.

 

Now given the above, if you are required to look for Narration not containing the character string say ~ invoice. It can be done as below ~

 

(A) Direct Extraction. Using the criteria .NOT. @isini("invoice", Narration)

 

(B) Search under Data. Enter NOT *invoice* in the Text to find box in Search under Data.

 

Please note in (A) above the logical operator NOT is entered as .NOT.

 

Whereas in (B) it is entered as NOT.

 

Best Regards

 

Group Admin Team