General discussion

I am currently at the 2016 IDEA users conference called Bright Insights.  It is a two and a half day conference in Orlando, Florida.  I presented this morning with my friend Sunder Gee on "Concepts to Automations: A Collaborative Approach" which talks about how we have collaborated over the years on creating IDEAScripts.

The Director for Product and Corporate Marketing at CaseWare Analytics, Anu Sood, is blogging about the conference over at the CaseWare Analytics web site.  So for she has posted four blogs:

Greetings
I am getting started as an  Idea Scripting and Training Contractor after leaving Caseware recently. 
Any thoughts, leads, support greatly appreciated and anything I an do to help out as I am new to Brian's site here but hope to become a regular.

Interesting blog by Alain Soubliere over on the CaseWare Analytics web site: http://www.casewareanalytics.com/blog/data-analytics-secret-tool-savvy-…

The following code, generated by Excel 2013 VB, with the nessassary changes , will not work: 
 
    wbOut.ActiveChart.SetElement (msoElementPrimaryCategoryAxisTitleAdjacentToAxis)
ex.Selection.Caption = "Month"
    wbOut.ActiveChart.SetElement (msoElementPrimaryValueAxisTitleAdjacentToAxis)
  ex.Selection.Caption = "Revenue"
 
The Category Axis title is ok, however Idea will not let you add title to the Value Axis.

Interesting article in accounting today about getting management to buy in with the use of Data Analytics.  http://www.accountingtoday.com/accounting-technology/news/getting-the-b…

David Coderre who is a long time data analytics guru is writing a blog about his career.  He recently retired from the Canadian Federal Government.  You can check out the blog here: http://caats.ca/blog/

Hi Brian
Is there a system field that holds the name of the running script?
for example: I have few versions of the same script. They are all having the same name suffixed by V1, V2, V3, etc.
The scripts generate excel files and I want to make sure the generated excel files are stored in different folders, depending on which version of the script is running.
 
Thanks a lot!
Avi

Does anyone know of an IDE (Integrated Development Environment) that integrates IDEA Script? I wasn't able to find anything of use when it comes to the generic IDE's out there. 
Essentially, I am looking for: 

• IntelliSense (or something similar) 
• Debugger
• Stack Watching
• Library references
• and all of the rest of the generic goodies. 

Thanks and I'll be waiting to hear back, 

Hi Brian, how are you?
I have a problem. I want to remove the character " from a field. I do not wisht o use @strip because it removes all special characters. I could not find a function that will accept " as the character to handle (replace, remove, etc. - they all failed)
Thans!
Avi

Looks like IDEA has released V10.1 and from what I was reading it has added lots of new features for the visualization part of the app.

Check out the blog for more info and screen shots: http://www.casewareanalytics.com/blog/product-close-what%E2%80%99s-new-…