Regular Expressions - Simple Matching Quiz
Try out this quiz to see your understanding of the simple matching with @RegExp.
IDEA v9
IDEA v9 was recently released to users for upgrade or purchase. You can find more details on the IDEA web site.
I was fortunate enough to be one of the beta testers on the project and enjoyed working with the upgrade. Here are a few of the new features of the product.
The most obvious is the use of ribbons instead of menus. IDEA has gone the Microsfot route of using ribbons. It takes a bit of getting used to after so many years using menus but once you have used it long en
- Read more about IDEA v9
- 4 comments
- Log in or register to post comments
Check if File or Directory Exists
This snippet will check if a file or directory exists. It returns true or false and you send the full pathname and filename. I adapted this snippet from one I found at http://www.vbaexpress.com/kb/getarticle.php?kb_id=559
- Read more about Check if File or Directory Exists
- Log in or register to post comments
Duplicate Key Exclustion Video
This video will walk you through how to perform a Duplicate Key Exclusion.
- Read more about Duplicate Key Exclustion Video
- Log in or register to post comments
Duplicate Key Detection Video
This video will demonstrate how to perform a duplicate key detection on one or more fields and also how to use the output records without duplicates option.
- Read more about Duplicate Key Detection Video
- Log in or register to post comments
Join Video
This video walks you through why we would use a join, the 5 different types of joins and finally it shows you how to perform each of the 5 joins.
- Read more about Join Video
- 2 comments
- Log in or register to post comments
Basic Direct Extraction Video
This video demonstrates how to perform a basic direct extraction. It also shows how to perform more than one extraction at the same time.
- Read more about Basic Direct Extraction Video
- Log in or register to post comments
Payment Date vs Due Date
This script allows you to take two date fields and perform three different extracts:
- First date field is less than second date field,
- First date field is equal to second date field, and
- First date field is greater than second date field.
It will then summarize the findings based on year and month. You can select which date field to use for obtaining the date and month information.
Script updated Feb 12, 2019
- Read more about Payment Date vs Due Date
- 6 comments
- Log in or register to post comments
Text Search
The text search script gives you an alternatvie interface to performing a text search from within IDEA. The script allows you to select up to 10 different search terms (you can use the wildcards), it also allows you decide if the search is case sensitve or not and the type of search, i.e.
- Read more about Text Search
- 10 comments
- Log in or register to post comments
Snippets
- Read more about Snippets
- Log in or register to post comments