Automate text update in BookMark of MsWord using LabVIEW

I am uploading the VI snippet to automate the text update in the defined bookmark field of the Ms Word document.

LabVIEW Keyboard Shotcut for Objects & Movement

Today I learned one hidden trick to scroll through the Event, Case Structure & Stacked Sequence. Most of us know Ctrl + Mouse Wheel shortcut used to scroll through the Event, Case Structure & Stacked Sequence states one by one.  But if we use Ctrl + Shift + Mouse Wheel it scrolls through every 5th case/Event/Sequence state (Like 5,10...) from the beginning state (0 state). It will work only if we have more than 5 case/Event/Sequence states. I verified this Keyboard Shotcut in LabVIEW  2009

Moving (Running) Average using LabVIEW function without loop

Today I learned one trick from NI discussion forum to calculate the Moving (Running) Average without using loop. FIR filter LabVIEW function used for this calculation. See the attached screenshot & VI snippet code below.

Strip a path using Build Path function

Today I learned one LabVIEW trick from my colleague Balaji. He showed me how to strip a path using build path function. I attached code snippets of the trick below.

Remove duplicate element & Sort the Array

Using varient function we can remove the duplicate elements & sort the elements of the array (Numeric,String array...). You can find the varient functions like "Set Variant Attribute"," Get Variant Attribute" in block digraram-> Function Palatte-> Cluster,Class & Varient -> Varient (LabVIEW 2009). By using those function without implementing anyother logics we can achieve removing duplicate element & sort array. It will work in String,Numeric & reference array also. See the simple exampleVI snippet attached below.
Front Panel : 

 Block Diagram :

Automate Powerpoint Macro execution using LabVIEW ActiveX

Using LabVIEW ActiveX functions we can call the powerpoint library to execute the macro of the opened Powerpoint file (*.ppt). Example code attached as a VI snippet. This VI module is tested using MS-Office 2003.

Multiple Patterns in LabVIEW File Dialog Tool

To display the multiple pattern files in File Dialog window use the string format (In File dialog tool-> Pattern terminal) as shows in the below picture.This Example picture shows the text & document file pattern configuration.

Learn Xcontrols - Basic Tutorial & Example links

Tutorials :
http://www.ni.com/white-paper/3198/en
http://zone.ni.com/wv/app/doc/p/id/wv-2695
http://prolucid.ca/xcontrols-2/
http://labviewwiki.org/XControl
https://decibel.ni.com/content/docs/DOC-3623

Examples :
https://decibel.ni.com/content/docs/DOC-7391
https://decibel.ni.com/content/docs/DOC-22536
https://decibel.ni.com/content/docs/DOC-1180#comment-1111

Useful links to learn SQL & LabVIEW integration

http://www.1keydata.com/sql/sqlorderby.html

http://www.blackwasp.co.uk/SQLForeignKeys.aspx

http://sqlcourse.com/select.html

http://sqlzoo.net/select

http://forums.ni.com/ni/board/message?board.id=170&thread.id=433683&view=by_date_ascending&page=1

http://forums.ni.com/t5/LabVIEW/LabVIEW-DataBase-Connectivity-Toolkit-Cheat-Sheet/m-p/847481?jump=true

Launch the system module window using LabVIEW

In LabVIEW, to launch the system module windows like regional & language option,Date & time properties use the "System Exec.vi" function. See the example VI snippet (LV 2009) for launch the regional & language option window.The non-connected string constant displays the command for launch Date & Time properties window.

Useful Links for LabVIEW Software Configuration Management

Use Graphical Merge To Combine Individual LabVIEW VIs
http://zone.ni.com/devzone/cda/tut/p/id/6212
Using new LabVIEW Merge Tool LVMerge With TortoiseSVN
http://expressionflow.com/2007/08/28/using-new-labview-merge-tool-lvmerge-with-tortoisesvn/
Using Source Code Control with LabVIEW 7.x and Perforce
http://zone.ni.com/devzone/cda/tut/p/id/4631
How do I use Subversion (SVN) and TortoiseSVN for source code controlling LabVIEW projects
http://digital.ni.com/public.nsf/allkb/C751F800E258087B86257535006DB160
LabVIEW & Mercurial
http://www.labviewwiki.org/Mercurial
Removing svn folders from a working copy with tortoisesvn
http://thinkinging.com/2008/09/23/removing-svn-folders-from-a-working-copy-with-tortoisesvn/
Source Code Control and Group Development Practices in LabVIEW for Advanced Configuration Management Tasks
http://decibel.ni.com/content/docs/DOC-2936
The easiest way to use TortoiseSVN in your LabVIEW™ projects
http://jki.net/tortoisesvn-tool
Integrate Graphical Diff with Subversion Source Code Control
https://decibel.ni.com/content/groups/large-labview-application-development/blog/2011/03/16/integrate-graphical-diff-with-subversion-source-code-control#comment-16435

Find Average(Mean) for 2D array values

There is an easy way to find the mean(average) for 2D array values without using any loop. The function name is A x B.vi which is located in the mathematics->Linear Algebra->A x B.vi.

See the picture to find the average for Row of 2D array values.To find the average for column of 2D array values just use Transpose 2D Array function on the 2D array input.

LabVIEW Tips- Format into String function

Format into string function has an option to change the order of the Inputs appear in the resulting string by giving “n$” specifier in the format string terminal. ‘ n‘ denotes order of the appearance in the resulting string .See the attached Picture.