General discussion

Hi again,
I'm having an issue with Client.WorkingDirectory
I'm running a script that places files into a folder "Audit Data".
As part of this script it opens one of these files, places a URL into a field, creates this as an action field, and then looks to another macro to invoke I Explorer
If I put the full path of the second macro into the script it works a dream. However, the macro will be used by different people and so the path will change.

Hi folks,
I'm writing a script that involves several summarizations.
In some cases, the output rearranges the fields/columns in a way that is not very user friendly.
Is there any way of specifying the order of the fields/columns of the output file via the script?
Thanks,
Phil

Hello everyone!
I am new in IDEA, but for me the IDEAScripting isn't that efficient taking about the macro editor. 
I search in this forum and realize that some people recomended to use Notepad++ to make life easier.
My question is: What is the path that I should provide to Notepad++ in order to run the macro into
the IDEA?

I just found this article on the audimation web site, nice read, "How Data Analtyics Opens Opportunities, For IDEA Users, By IDEA Users".

http://www.audimation.com/Resources/Articles/how-data-analytics-opens-opportunities-1683

Is it possible to calculate the 2 different dates in months or years? ? 

I'm working in IDEA and I'm trying to extract specific information in a certain column. I deal with lots of data so when I'm looking for specific data only pertaining to a certain date, field or column, etc. I should be able to extract that information only. In the attached image you can see blue numbers in the NO_OF_RECS column.  I should be able to to click on the blue numbers and it pull up the database for those records only. Mine is not working. No one else in my company who uses this program is having this issue.

CaseWare Analytics have a new blog posting on tips on how to use pdfs.  Of the four tips three of them come from this site 

https://www.casewareanalytics.com/blog/idea-tech-tip-using-pdfs

Hello,
I was wondering if it's possible to automatically attach and e-mail an exported database to myself? I'm trying to incorporate this into my script. 
Thanks. 

Hi,
Excuse me. This might be an out of box  question. 
In IDEA Smart Analyzer tab, there is a 'Select and Run' option from which we can see routines imported into Smart Analyzer and execute routines.
My requirement is given below:
I have to list the routines showing under the 'Select and Run' in a separate windows application.
I would like to know if there is any library that I can refer and call method to list routines imported into IDEA Smart Analyzer.
Thanks,
Shafeer

 
HELP!  Is there a way to normalize vendor names in Idea? For example, AMAZON MKTPLACE PMTS to AMAZON, WAL-MART002 to WAL-MART, UPS 091238547 to UPS...etc? 
 The database I’m working with has at least 500,000 records. 
Thanks in advance