Checking for a list of charcters in a string
I came up with this function while trying to validate a filename for a script. The function will take a string and a list of characters to look for and will return true if the string contains one or more of those characters. An example would be looking for \/:*?"<>[]| as these characters should not appear in a filename, so if they exist the filename is not valid. You would call it in the following way:
checkForSpecialChar(newFilename, "\/:*?""<>[]|")
- Read more about Checking for a list of charcters in a string
- 2 comments
- Log in or register to post comments
Using listboxs to select files/fields
A common problem with IDEAScript is there is no easy way to select multiple files or fields. This script shows you one way of performing this operation. This is a working example script. It has a main menu that allows you to open the listbox dialog. The main menu also allows you to select which type of fields you want to display, when you select ok you will have a message box of the fields that you selected. You can download the code.
- Read more about Using listboxs to select files/fields
- 20 comments
- Log in or register to post comments
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