General discussion

Hi everyone,
 
I'm new on IDEA and I'm doing my first scripts.
I would like to convert a string into a number format as for example "102.23", I found the function @Val but this one only works on the first figures: @Val(102.23) returns 102.
I could combine this function with the function Split to work arround the coma, but it should exist a simpler method, and I can't find it.
Which funtion should I use?
 
Thank you very much for your help
 
Mac

Hi! Can you help me!?
I'm learning how to do some scripts, but really (really) new to it.
I'm currently trying to create a script that uses the same file to do different things.
Now I'm oppening the file a lot of times to get it's different sheets.
Is that possible to create a function to open the file, and then get those different sheets? Probably passing the address of the file as a parameter.
</code>
Sub Main
Call OpenFile()
Call ExcelImport_sheet1()
Call ExcelImport_sheet2()
Function OpenFile

Hello!
Is it possible to create a script that calls another script?For example, inside a Dialog made with IDEA script langauge i have a button.If i press that button, another script, made in Python will be called to do something.
Is that possible? How can I do that?
Thank you!

I am working on putting more controls in place to check for user input errors when I am building dialog boxes that require user interaction. 
Right now I have a listing of checkboxes to allow the user to select which tests they would like to run.  Out of the five items I have, there are two that cannot both be selected.

Greeting fellow IDEAScripters!
Does anyone have a list of keywords that they use to search for Meals and Entertainment for their comany's T&E program. I am currently looking to try and gather some data on our Customer Meals and Entertainment. Thanks in advance!

Good afternoon,
I am trying to add leading zeros to a character field and want all values in the field to have a character length of 9.  For example, I would like 1234B11 to be 001234B11.  Is there any easy way to do this within the Equation Editor window?
 
Thanks!

Hello everyone, if you have been wondering why I am not around as much as I have used to be it is because I have changed jobs.  After 30+ years with the government of Canada I have retired and joined CaseWare IDEA as an Industry Strategist (Solutions Lead) on their Industry Team.  This will be a great challenge but after five weeks with the company I am loving it.  Because of this change I no longer have time to keep up with the boards on a constant basis, also I no longer have the time to create special scripts for people.  If you have suggestion

While using the function Mid(currentLSD, 5, 2) I am getting stackoverflow error .
 

 
A while back, I used the script in the link below to identify hospital overlap. 
https://ideascripting.com/forum/overlapping-dates
 
Hospital overlap occurs when a provider bills a patient for service at doctor's office, home, etc. while the patient is actually in the hospital. The script in the link did identify the overlap. For example:

Provider
Start Date
End Date
Over Lap

Hi all,
I have recently moved roles from an commercial role to a consulting role. With the new role, I have noted that I would have to request for data extracts in order to perform analytics.
Would you be able to provide me with some tests that you would do to validate the data for completeness? Some of the tests I perform are:
- identifying blanks in key fields,
- verfiying the transaction dates to ensure the audit period is captured,
- number sequence check (where numbers are meant to be in sequence),