IDEAScript suggestions
Suggestions for useful IDEAScripts
SimilarPhrase Loop on Array
Forums
I need to identify all transactions involving certain companies in a dataset. Since the names on my company list won't exactly match the names in the transaction dataset, I plan to identify variations using @similarphrase. I have over 100 companies to search for in the dataset so I am trying to define an array containing the 100 companies and create a loop so that the @similarphrase function is performed on all 100 names. I would need the output to be a separate column for each company name. I am fairly new to IDEAScript and am having trouble getting this to wo
- Read more about SimilarPhrase Loop on Array
- 8 comments
- Log in or register to post comments
Append multiple files from same folder
Forums
I had a request from another posting about a script that would append multiple files from the same folder. I had already created one in the past but it lacked any user input, I have changed that with this one. So once you run the script you will have a message saying all the idea files should be stored in the same folder under the project directory. You will then have an input box that will ask you the filename for the new file (don't add the file extension). The script will then read all the IDEA files in that directory and append them together.
- Read more about Append multiple files from same folder
- Log in or register to post comments
Copy Header Info
Forums
This script was requested from a coleague of mine. It might be useful to anyone that has data files in which the header info is only found on the first database.
The script will copy the header info from one file to another file. This can be used when importing an excel file in which the data is over several tabs but the header info is only on the first tab. The script will take the header info from the first and copy it to the second file.
- Read more about Copy Header Info
- Log in or register to post comments
Merge Records
Forums
This script was developed based on a request from the IDEA forums. As I can't attach any items on that forum I have atteched the script here.
- Read more about Merge Records
- Log in or register to post comments
Script for Joost
Forums
This is a script that will import a series of excel files and add a virtual field. The script first asks for the folder in which the excel files are located and then it asks for the name of the worksheet. The worksheet and format must be the same for each excel file. Line 116 of the script hold the eqn for the virtual field, it will need to be changed based on the needs of the script.
- Read more about Script for Joost
- Log in or register to post comments
Payments before due date (accounts payable analysis)
Forums
Hi!I am looking to perform an analysis of an accounts payables where I can see any payments of supplier invoices going out before due date. I would like to generate a list showing total amount per credit being paid before due date, preferrably in a month by month format.This analysis would be useful for fraud investigations on for example bankruptcies. Does anyone have this script available or could help me out in any way?Many thanks!