Loop

added on August 30, 2007 by Marjo Martinez

Applies To:
AutoMate 6, AutoMate 5

This simple task will illustrate how AutoMate&apos;s &apos;Loop&apos; action works. A variable is created in which to populate the index count. The task will simply loop a &apos;Message Box&apos; step 6 times. The variable specified in the Index parameter is updated with the current loop count.

Round up to Whole Number Using VB Round() Function4/24/17
• Leonard Amabile

The VB round() function, by default rounds to the nearest whole number based on the following:
10.00 through 10.50 = 10
10.51 through 10.99 = 11
There are scenarios where you want to round up all decimal values to the nearest whole number. Based on the above criteria, adding 0.5 to any numeric value with a decimal will cause the round() function to round up. For example:
10.00 + .50 = 10 round(10.5)
10.10 + .50 = 11 round(10.6)
10.90 + .50 = 11 round(11.4)
The attached tasks will demonstrate the round() function usage to round up numeric values.

Restart a Service (Automate and Intermapper)3/27/17
• Network Automation

This sample task will allow you to use Automate and Intermapper to restart a service.

DDE Sample (task)2/24/17
• Leonard Amabile

The attached task demonstrates DDE Execute, DDE Poke and DDE Request. The task assumes that Excel is running with a worksheet named Sheet1.
DDE Execute: Maximizes the Excel spreadsheet.
DDE Poke: Will write the number 7 in row 1 column 1 of Sheet1.
DDE Request: Will grab the value from row 1 column 1 of Sheet1 and populate variable varTest.

Workflow Loop Sample (workflow)8/22/16
• Leonard Amabile

This sample demonstrates how a workflow loops through a shared dataset using the evaluation object and NO loops within the tasks.

Inline Padding Sample (task)8/22/16
• Leonard Amabile

This sample demonstrates how to pad a string inline with leading or trailing spaces.

Split filename into two variables5/15/15
• Valentineo McGowan

A task has a name of 'abc_123.txt'
I would like the folder name to be the prefix of the filename prior to the "_" delimiter 'C:\abc'.
File 123.txt will then be placed inside C:\abc\123.txt

I have a *.txt or *.csv containing column headers and X rows of data.
Using RegEx the task simply counts the number of rows based on carriage returns.
Great for csv files that have X amount of records and you simply need a total count of rows minus the headers.

Dataset to CSV File using Excel action5/15/15
• Valentineo McGowan

How do I create a CSV file from a dataset without using Interactivity actions inside MS Excel, ie, 'File Save As.'?
Here's how to create a CSV file in one step using a dataset with our 'Excel - Set cells' activity.

Dataset to CSV using ODS action5/15/15
• Valentineo McGowan

How do I create a CSV file from a dataset without Microsoft Excel being present on my machine?
Here's how to create a CSV file in one step using a dataset with our new 'ODS (OpenDocument Spreadsheet) - Set cells' activity.