IDEASnippets
Test to see if Array is empty
This function will test to see if an array is empty or not and will return true or false. I added a line at the beginning of the function to make sure the err.number is 0, I had it happen that it would show an error but the error wasn't caused by the testing but by something else.
The following is an example on how to use it:
Dim myArray() as string
- Read more about Test to see if Array is empty
- Log in or register to post comments
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
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
Action Field
This snippet was created by CB and it allows us to use IDEAScript to create an action field. The function takes three parameters:
The master file, this is the file in which the field will hold the action (i.e.
- Read more about Action Field
- 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
Remove Blanks from an Array
This function will remove any blank elements within an array.
- Read more about Remove Blanks from an Array
- Log in or register to post comments
How to sort an array
Somteimes you need to be able to sort an array. This function will take a single array and sort it in alphabetical order.
- Read more about How to sort an array
- 7 comments
- Log in or register to post comments
Log10
This function will return a Log10 value
- Read more about Log10
- Log in or register to post comments