renameFields Function

Brian Element

Function: renameFields
Purpose: To rename fields within a file
Input:    sTempFilename: the name of the imd file that contains the fields to change
             sOldFieldName: The name of the field that is to be changed
             sNewFieldName: The new field name
Returns: True if fieldname was changed False if the field name could not be changed
Problems: Currently does not work for some Editable fields

Export Delimited File

Brian Element
Background

This script gives additional options for anyone wishing to export an IDEA file in a delimited format.

2015-08-15 - Updated the script so that the if you user select to include field names that they are separated by the selected field separator and not the ",".  Also added code to format numbers, it seems that if you had a number like 12.10 it would be stored in the text file as 12.1, this has been fixed.

Date Picker

Brian Element

One of the items that the IDEAScripting dialog lacks is a date picker.  I recently saw a post on the IDEA forum that they had the script for one but for some strange reason weren't releasing it on the scripting section, so I decided to try and create a date picker for my use and anyone else that wants to use it.

The attached script has the code for the date picker along with an example of how to use it with a dialog that asks for the user to enter a date.

When you start up the example script you will have a dialog with two edit boxes where the user can enter a date:

Import Multiple Files

Brian Element
Background

This script is now available as a SmartAnalyzer application, it is available through Passport with the Utilities SmartAnalyzer applications.  Please consider purchasing this application as it helps to support this web site.

This script will allow you to select and import multiple files at the same time.

March 16, 2014 - Updated - added an option for delimited files to select the first row as the field names.

April 8, 2014 - Updated - there was a bug in the select files dialog that would not allow you to move a file from the right panel to the left.

DateDiff()

Brian Element

Syntax: DateDiff(Interval as String, Date1 as Date, Date2 as Date, Optional DayOfWeek, Optional WeekOfYear) as Long

Parameters:

Interval - There are 10 different types of intervals.  Depending on the interval the DateDiff() well return the number of units in the Interval.  Below is a list of the 10 items.  In the script below I used constants to better define them.

Parameter

Test to see if Array is empty

Brian Element

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

Checking for a list of charcters in a string

Brian Element

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, "\/:*?""<>[]|")

Using listboxs to select files/fields

Brian Element

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.

Subscribe to
© 2025 IDEAScripting and More, All rights reserved.