Skip to main content

IDEAScript Questions

Error Handler by Function

Hello, 
I've written a set of functions within a single script that completes various tasks. Each function has its own error handler with the intention of logging which function the error occurred so I can quickly isolate a potential problem to one single function. However, during my testing I've noted that when an error occurs in one of the functions it calls the error handler in all of them. Is there a way to fix this or perhaps build a single error handler for the whole script that will log from which function the error originates. 

Extract only the rows, which have a defined symbol in "cell"

Hello, I was an Excel user before, but have started to work with IDEA for a while. First of all sorry if will use such definitions as "cells" etc. I have a database, it looks like
UserName | bla | bla2| bla 3| .....
Superman | 1     |   2   |    3    |  .....
Hyperm_n | 4   |   5    |    6    | .....

Close all databases

Hello,
Part of a script I am working on includes a direct extraction.  I want to close both the original database and the extraction database once the extraction is complete.  I added Close but that only closes the extraction database (script attached).  I also tried Close All but obtained the same result.  My apologies if this answer exists somewhere on your site already.  I tried several searches and wasn't able to find it.  Thank you very much!  
Holly
 
 

Macro that will import new files monthly

Hi,
I am fairly new to IDEA script, and I am trying to modify a macro so that it will import two new files monthly that we receive from another department.  The file names are the same except for the date at the end which is why I have tried using an input box that you can see in part of my script attached.  I am getting many syntax errors and am having trouble working around them.  Is there a better way to go about this?
 

Split tables according to a field value

Hi all :)
I have a table "TableOne" that contains n fields. In field "Fieldn" there are codes like C1, C2, C3 etc.
I would like to be able to split tables: TableOne_C1, TableOne_C2, and so on.
Basically like: on every change in the column X create an extract with the new value as table-suffix.
Any suggestions?
regards from Berlin

Wrap character fields using script

Hi,
There is an option to wrap character fields under View. User has to select a column and click on this option to enable it.
I have to show a description field in my output file which is generated through idea script.
Width of this column is 200 and there are some other columns.  While opening the output file, user will not be able to see other columns without moving scroll bar as the width of the column is high. Is there any way to wrap text of this column programmatically?
Thanks,
Shafeer