I developed this code because one of my other in-progress projects needs this as a sub-function. I am porting my Duplicate File finder program written in Visual Basic to RIPE , I am fed up trying to get my Visual Basic program to run on a naked, newly installed, Windows environment. My Visual Basic version has so many dependencies that I basically need to install a complete .Net environment to get my program to work. Since RIPE runs on a naked newly installed Windows then I have decided to stop the Visual Basic development (actually its finished) and re-do it all in RIPE .
One of the features of my Visual Basic version is that you can search the embedded SQLite database to find matching files, so I need a field on the screen in to which you can enter the search criteria. But I do not want that the user must “learn” SQL syntax.
So I use my own syntax checker. There are various search criteria, one of which is the file extension. So if the user wanted to include only say image files they could enter in to the appropriate screen field:
(Yes I know it could be done differently JPG and GIF , but I wanted to show use of the NOT operator)