AutoMate URC Home

  • Home
  • •
  • Blog
  • •
  • Tutorials
  • •
  • Sample Tasks
  • •
  • Knowledgebase
  • •
  • Support & Documentation
  • •
  • Versions
Support > Sample Tasks > View Sample Task

Delete Last Line of a File (vbscript)

added on August 10, 2010 by Leonard Amabile
Applies To: AutoMate 6, AutoMate BPA Server 7, AutoMate 5, AutoMate 7, AutoMate 8, AutoMate BPA Server 8

This sample task will demonstrate how AutoMate can delete the last line in a text file using vbscript.

The task will invoke a vbscript that will remove the last line within a text file. The variable, varFileName, will require a valid path and file name in order for the script to function properly.

Download This Task (2.1kb) 4d6feb2a8d08c421420886.zip
Would you like to upload a Sample Task to the User Resource Center? Click here!
Tweet



More Sample Tasks

OCR & Active Directory Sample Task 2/7/12 • Network Automation

The new AutoMate and BPA Server 9 OCR actions have the ability to read, extract and convert ANY type of image, such as a bitmap, jpeg, png, pdf or tiff file into text for electronic automation and importation. Our extensive set of Windows Active Directory actions provides creating, modifying and managing any type of Object, User or Group. This task will read a name, address and telephone number from an application image, and create an Active Directory User with AutoMate’s OCR, Active Directory, Loop and Flow Control Actions.

OCR & Active Directory Sample Workflow 2/7/12 • Network Automation

The new AutoMate and BPA Server 9 OCR actions have the ability to read, extract and convert ANY type of image, such as a bitmap, jpeg, png, pdf or tiff file into text for electronic automation and importation. Our extensive set of Windows Active Directory actions provides creating, modifying and managing any type of Object, User or Group. This sample workflow will read a name, address and telephone number from an application image, and create an Active Directory User with AutoMate’s OCR, Active Directory, Loop and Flow Control Actions.

Using the split function to parse a text file 12/19/11 • David Hubbard

The sample program writes out a table text file to be used as input. Normally this would be created using a text editor such as Wordpad or Textpad. Excel could be used for table-driven processing as well. Excel is more powerful and versatile while text is faster and uses less memory. The text file of parameters is read in and separated by the character '#'. In the example it just displays the table parameters as they are read, but in general the parameters would be used to perform some table-driven process. Each line is split into three words using the Split() function and puts each word into a separate variable.

Executing a DOS command and saving the output 12/8/11 • David Hubbard

This example executes the DOS 'dir' command on the C: drive and puts output into a text file for further processing. It is based on the blog "Executing Command-line Applications Using The Run Action". The C:\ drive in this example could be substituted with any mapped drive or folder. The 'dir' command has many options to obtain a variety of directory/file information. Any DOS command can be substituted for the 'dir' command in this example to capture the output of the command in a file.

Creating a Radio Button List from an Array 12/2/11 • David Hubbard

A radio button list is an example of how to display a menu of options. One way to populate the list is by using an array. This is a simple example of creating the menu with an array of values. After the prompt, the program displays the selection.

Sample Workflow: Memory, Disk Space Monitoring 11/7/11 • Network Automation

This sample workflow for Business Process Automation (BPA) will demonstrate how to solve a computer and/or server problem by adding resolution automation management, system gathering and reporting for troubleshooting and speedy recovery.

Update Your Tweets with AutoMate 8/22/11 • Network Automation

Are you diehard twitter-er? If you are one of them, you most likely tweet using one of the many different ways to post updates: from the web in the update box, from your phone, from your mobile web browser, or from a third party application. This sample task allows you to tweet at the comfort of your computer without logging on to your personal or business twitter account. In fact, use a hot key trigger (e.g., Alt + A) to open a dialog box, enter your tweet, and press Enter.

Get @Mentions Tweets and Populate to Excel 8/16/11 • Network Automation

A mention is any Twitter update that contains @username anywhere in the body of the Tweet. This means that replies are also considered mentions. Twitter collects these messages, as well as all replies, and stores them in the @Mentions tab on your twitter homepage. This sample task connects to your personal or company twitter account, reads all tweets in the @Mentions tab, populates them in an Excel spreadsheet by Date Created, Twitter Message, and Twitter User, and sends an email notification with an Excel attachment. This task allows you to automate the monitoring of all activities related to your twitter account on a regular basis without having to logon to Twitter or manually parse through large volumes of data.

Create a dynamic selection list of month and years 8/4/11 • Edward Hulleman

It can be handy sometimes to give the user a selection list of month and year, for example to generate a report for that certain period. This task generates the list and considering the current month it adds a year for months that have passed already. So when you run this in March 2012 it will show January 2013 Februari 2013 March 2012 April 2012 etc The selection shows next month as default. Edward Hulleman, Aug 4 2011

Create/Send Encrypted AS2 Message 7/18/11 • Network Automation

AS2 (Applicability Statement 2) is a standard that defines security requirements for sending and receiving EDI over the internet (EDIINT) using certificates and encryption. This sample task demonstrates how AutoMate creates an AS2 message containing an XML file attachment called book.xml, encrypts the message using a certificate native to AS2 and digitally signs the message using a certificate and key. The AS2 message is then transmitted over the internet (EDIINT).

 

Comments (0)

What are you thinking?
There are currently no comments, speak your mind!

Search the URC

Subscribe to Version History via RSS
Subscribe to Version History via RSS
Version Watcher

9.0.0.0 changelog
9.0.0.0 changelog
other versions downloads

Contribute

Upload a Sample Task Post to our Discussion Forums
in our blog: Ask an ASE, AutoMate News, Automation Strategy, CEO Corner, Founder's Corner, In the News, Inside Development, Meet Our Team, Success Story, Task of the Month, Tech Talk, Thread of the Month, Webinar Schedule

Subscribe to Latest Resources via RSS
Subscribe to Latest Resources via RSS
Latest Resources

Resources to include:
Save Changes
show filter options
  • blog
    post
    OCR & Active Directory Automation
  • sample
    task
    OCR & Active Directory Sample Task
  • sample
    task
    OCR & Active Directory Sample Workflow
  • blog
    post
    Be Nice to Nerds
  • blog
    post
    Share your Best IT Story on Spiceworks for a Chance to Win a Kindle Fire
  • blog
    post
    AutoMate Online Classroom Training for March
  • blog
    post
    Network Automation Announces Q2 FY12 Results, Revenues up 13.6% Over Previous Quarter
  • video
    tutorial
    Getting Started With AutoMate 9
  • blog
    post
    Automating Stored Procedures
  • sample
    task
    Using the split function to parse a text file
  • blog
    post
    AutoMate Online Classroom Training
  • blog
    post
    AutoMate Now on Google+
  • blog
    post
    Automate SharePoint Uploads
  • blog
    post
    AutoMate 8 Named Best Task Automation Product for 2011 Windows IT Pro Awards
  • sample
    task
    Executing a DOS command and saving the output

Subscribe to Forum Posts via RSS
Subscribe to Forum Posts via RSS
Forum Posts

  • 2/1/12 3:36pm Auto Logon with security pop-up Windows 7
  • 1/24/12 11:53pm Reading first line of file
  • 1/23/12 7:32am Clean out directories
  • 1/23/12 1:14am Restart service on remote machine?
  • 1/20/12 3:00pm TN5250 {PGUP} and {PGDN} not working (#3529)
  • 1/19/12 2:28pm Task could not start because the specified interactive session (session "7") could not be located.
  • 1/19/12 8:49am Deleting Folders by date
 
A BBB Accredited business since 05/11/1999 Find Network Automation on Facebook Follow Network Automation on Twitter Find Network Automation on Linked In
© 2004-2012 Network Automation, Inc. All worldwide rights reserved
  • Blog |
  • Privacy Statement |
  • Contact Us |
  • Sitemap
Welcome to Network Automation, developers of AutoMate and AutoMate BPA Server
Sign In  •  My Account  •   Contact Us  •     
Network Automation Software Home full menu
  • Overview
    • Why Business Process Automation?
    • An Introduction to Business & IT Process Automation
    • Business Process Automation Solutions by Industry
    • Business Processes That Are Commonly Automated
    • Business Process Automation Solutions for People
  • Products
    • AutoMate 9
    • BPA Server 9
    • Features
    • Demo Videos & Recorded Webinars
    • AutoMate in the News
    • Literature & White Papers
  • Services
    • Online Classroom Training
    • Personalized Training
    • Product Implementation
  • Downloads
  • Purchase
    • AutoMate & BPA Server
    • Product Maintenance
    • Product Training
    • Implementation
    • Product Support
    • Purchase From a Reseller
  • Partners
    • Find a Partner
    • Partnership Overview
    • Partnership Benefits
    • Apply for Partnership
    • Partner Portal
    • Contact
  • Support
    • Blog
    • Tutorials
    • Sample Tasks
    • Knowledgebase
    • Online Technical Support
    • Version History
    • Forums
  • News
    • AutoMate in the News
    • Blog
    • Press Releases
    • Case Studies
    • Automation Webinar
  • Company
    • About NAI
    • Management Team
    • Careers
    • Contact
    • Logo Downloads
Questions? email | (888) 786-4796