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
Get most recent file from a directory
I found this snippet by doing a google search and adapting it to IDEA. It will return the name of the most recently saved file from a directory. With a bit of change it should also find the most recently modified file from a directory.
- Read more about Get most recent file from a directory
- Log in or register to post comments
Create a delay
This little snippet will allow you to delay your code by x number of seconds. Just use the call wait(x) where x is the number of seconds you want the script to pause.
- Read more about Create a delay
- Log in or register to post comments
CStr()
The CStr() will convert numeric and date values to a string format.
- Read more about CStr()
- Log in or register to post comments
CSng()
This function will change a number into a single type. A single type has 4 decimals so any decimals larger than 4 will be rounded to 4.
- Read more about CSng()
- Log in or register to post comments