Use the iSplit to get the filename
This piece of code will extract the filename from a character string that contains the filename and path.
- Read more about Use the iSplit to get the filename
- Log in or register to post comments
Get the Excel Worksheet name
This example script shows how to obtain an excel worksheet name. This can be handy if importing an excel worksheet and you don't know the worksheets name.
- Read more about Get the Excel Worksheet name
- Log in or register to post comments
Check if a file exists
Short function that checks if a file exists, good for checking that a file or rdf file exists.
Returns true if the files exists else it returns false.
The function expects the name of the file along with the path information.
- Read more about Check if a file exists
- Log in or register to post comments
Unpivot
A small script that will take an IDEA file and render it into two columns with one column being the header names and the second column being the data.
- Read more about Unpivot
- Log in or register to post comments
IDEAScripting.com update
Hello everyone,
As some of you might have noticed the site has been down for that past month or so. The main reason was that the site needed a major refresh and the platform that I was using to create the site was nearing its end of life. Unfortunately, the platform had been rewritten since I had created the site so there was no easy upgrade path, that is why it has taken so long as there was lots of trial and errors on my part to get the site up and running with the latest software.
- Read more about IDEAScripting.com update
- 6 comments
- Log in or register to post comments
Timer
Code to time your script.
- Read more about Timer
- Log in or register to post comments
Array to hold all Field Information
I use the Type procedure that allows you to create a user-defined data type containing one or more elements. I create an element for each of piece of information that is contained in the field then I use this type as an array and populate it with all the field information. This is an easy way to get all the information on the fields in a database in a quick manner.
- Read more about Array to hold all Field Information
- Log in or register to post comments
Populate Select List Based on Drop-Down Selection
This is a demo program on how you can populate a list box based on a selected field.
Example of populating drop-down based on contents of previous drop-down
This demo script will show you how to populate a drop-down based on the contents of the previous drop-down. In this example it will take the contents of the field t
Extraction Based on Date
A small script that allows you to do an extraction based on a date. This script has been rewritten in Python.
- Read more about Extraction Based on Date
- 6 comments
- Log in or register to post comments