IDEAScript Questions
Replace words in txt file
Forums
I am working in a script that open an txt file and replace any caracter that I choose for another one, so far everything is ok.
The problem is when the file that I am reading contains quote marks(") as at example attached(input.txt).
In this case, when the script faces one line that contains a simple quote mark in the middle is enough for the program launch an error message to the user (image attached).
- Read more about Replace words in txt file
- 17 comments
- Log in or register to post comments
Checking for consequtive number within a group
Forums
Hi,
I am trying to write a script to find out the consquetive invoices of a vendor from vendor ledger.
Input (Consequtive check is a computed field)
Vendor number
Invoice no
Amt
Consequtive check
1
123
10
Start
1
124
20
Yes
1
125
30
Yes
1
301
400
No
1
302
200
End
2
2134
7000
Start
3
6162
100
Start
3
6163
100
Yes
Dealing with Folders
Forums
I've been trying to figure out a way to deal with user created folders.
Its very common for users in my organization to work with a set of databases in IDEA and then create a folder to organize them within the current directory. They will create a folder and then move the databases over. The problem though is many of the scripts that I have been written can not find those databases moved into those folders. The scripts will pull all the databases in the current directory unless they are within a folder.
- Read more about Dealing with Folders
- 12 comments
- Log in or register to post comments
Drop-down box
Forums
Hi everyone,
Can you please help me vb macro in idea
I have direct extraction equation below
@match(columnname,1000) and.columnname < 0
Where in scripting I need to change the column name by selecting drop-down and account numbers were changing Case by case so I need input different account numbers.
Please help me in this regard how to write macro for this.
Thanks in advance
Nagaraj Arali
- Read more about Drop-down box
- 12 comments
- Log in or register to post comments
How to add items to CirSimpleList in Dialog
Forums
Hi,
Can anybody tell me the syntax to add items to a CirSimpleList placed in Idea Scripting Dialog control?
Thanks,Rini
- Read more about How to add items to CirSimpleList in Dialog
- 3 comments
- Log in or register to post comments
counting last 5 days
Forums
i'm looing for somthing that keeps counting the last 5 days per id.
so from the fifth row, while the id is the same, i add the "amt" but if the "id" changes, it starts again.
for ex.
- Read more about counting last 5 days
- 12 comments
- Log in or register to post comments
Joining Tables when key is between two values (upper and lower)
Forums
Hello, this is my first post on this forum as I am a recent IDEA user.
This question has been crackling my brain recently without any success.
I am trying to calculate the tax retention of multiple employees.
Tax Retention tables have an upper and a lower limit, and 2 features. For the two features I can simply do a join matches only but is there any way to do a key join between a range?
Tax retention table example on the right side.Employee Info on the left.
I want to extract the tax% value for each employee based on the features and its value.
Counting while..
Forums
hi all,
new to idea scripting..
how can i create field that counts while somthing happans in other field?
foe example:
in every row, as long as Employee Number is the same, keep counting 1...2...3...4...
and when the number changes to another Employee, start all over again 1..2..3...
- Read more about Counting while..
- 10 comments
- Log in or register to post comments
Update Dialog based Drop Down Combo Box Selection
Forums
Is there a way to have the dialog update based on the user selecting from a Drop Down Combo Box?
Basically, I'm trying to have the user select a file from the drop down combo box and from this another combo box is populated with the fields from that selected file.
Any help would be appreciated.
Script to Launch Analysis function
Forums
Hello,
I was wondering if it was possible to write a script that will launch a specific analysis. For instance if I write a script where the user wants to summarize something. This would manually be done through the Summarization menu. Is it possible for me to take adavantage of the Summarization menu having already been built to run that anaylsis within the script?
- Read more about Script to Launch Analysis function
- 1 comment
- Log in or register to post comments