Action Help

Compares two variables to see whether or not they are equal.

If the comparison succeeds, the script actions between the If and End If script lines are executed. The If action can also be used in combination with an Else action.

Tip: The wildcard '*' can be used in a string compariment.

Test a "Variable" against a certain condition.

If the comparison succeeds, the script actions between the If and End If script lines are executed. The If action can also be used in combination with an Else action.

Tip: Use this action to verify if a variable is empty, or a file exists.

 

The Else action can be used in conjunction with an If or If Condition action.

When the If action fails, the lines between Else and End If are executed.
 

The End If action closes an If or If Condition block.

Structure example:

If ...
... do actions ...
Else
... do actions ...
End If

Jumps to a Label and resumes execution from there.
 
The "Label name" property value should match the exact name of the label to jump to. Use the Return action to jump back to the script position where Goto Label was called.

Note: Don't nest Goto label actions, it will confuse the script logic.

The Label action is used as a marker to be used with the Goto Label action.

The Goto Label action can be used to jump to a Label action and resume execution from there. Make sure the names in both actions match exactly. Use the Return action to jump back to the script position where Goto label was called.

Note: Don't nest Goto label actions, it will confuse the script logic.

Use the Return action to indicate the end of label and jump back to position where the Label was called via a Goto label action.

The Loop action is a simple infinite loop till the action Exit Loop is called.

All actions between the begin of the loop and end of the loop are processed infinitely.

Note: An End Loop action is needed to close the loop and an Exit Loop to exit the loop.

The While Loop is equivalent to the If action.

All actions between the begin of the loop and end of the loop are processed as long as the loop condition continues to be valid.

Note: An End Loop action is needed to close the loop.

The Condition Loop is equivalent to the If Condition action.

All actions between the begin of the loop and end of the loop are processed as long as the loop condition continues to be valid.

Note: An End Loop action is needed to close the loop.

Loops through a preset numerical range.

The looping process starts with Start Value and will stop when it reaches the Stop Value. With each loop, the Start Value gets incremented and passed to the Current Value variable. If the Step variable is given, this is used to increment the Start Value. If Start Value is larger then Stop Value, the loop counts down.

Note: An End Loop action is needed to close the loop.

Loops through a directory and feeds back all the filenames.

The names of the found files will be given back through the "Filename" variable. The filenames that are found are passed back on each run in the loop. Looping continues until no more files are found.

Note: An End Loop action is needed to close the loop.

Loops through a root directory and feeds back all the sub directories names.

The folder names are returned via the "Folder Name" variable. Looping continues until no more folders are found.

Note: An End Loop action is needed to close the loop.

Loops through a range of web pages in a "Web Page" source. The "Next Page Button Recorder" is used to identity a "Next" page button.

A Loop Web Pages loop should always be proceeded by a Open Web Page or Web Marco action. This should be done so that the Web Page source browser actually contains a page where the click to next page is performed.

Note: An End Loop action is needed to close the loop.

Often, data on web pages is divided over a range of successive pages. Search results in Google are an example of this. On the bottom of such a page, you will find links like: 1|2|3 >Next. Clicking on the Next link gives the next page of results. This Next link we call the "Next Page Button". That link is exploited by the Loop Web Pages action to loop through all result pages.

Loops all items contained in the List property and passes them on to the Item property.

The loop starts with the first item in the List and stops at the last. You can interrupt a the loop by using the Exit Loop action.

Note: An End Loop action is needed to close the loop.

Loops all records of the active record set related to a SQL database connection.

The loop starts with the first record in the record set and runs until the last record is reached.

Note: When the loop finishes it will apply any changes made to the database.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
Loop Records
... actions like Get Field Value...
End Loop
Disconnect

Loops through all the rows in a data grid and is often used in combination with the Get/Set Data Cell Value actions.

The "Current Row" variable holds the current row number, and can be used for further processing on consecutive rows, for example to get the content of a data grid fields.

Note: An End Loop action is needed to close the loop. The first row in a data grid has the number 1. 

Loops through all the columns in a data grid and is often used in combination with the Get/Set Data Cell Value actions.

The "Current Column" variable holds the current column number, and can be used for further processing on consecutive columns, for example to get the content of a data grid fields.

Note: An End Loop action is needed to close the loop. The first column in a data grid is has the number 1.

Loops through all the matches of a regular expression it finds in a "Source Text".

The loop tries to match the "Regular Expression" variable and with each loop it passes the result to the "Returned Match" variable. If the (last) match is unsuccessful the looping process ends and the script continues.

Note: An End Loop action is needed to close the loop.

Loops though all lines in a text (ASCII) file. With each pass the "Read Line" variable is filled with the last line that was read from the file.

The looping process stops when the last line in the file has been read.

Notee: An End Loop action is needed to close the loop.

Each Loop action needs an End Loop action to indicate the end of the loop.

Structure example:

Loop While ...
 ... actions ...
End Loop

Forces an exit in the current loop and is often used in combination with an If or If Condition action. When the Loop action is used an Exit Loop must be included in the loop or it will run indefinitely.

Comments are used to place notes in a script and make it more readable for yourself.

Tip: Use comments to separate blocks of code for clarity.

Note: A Comment action is excluded from the script action execute count.

Halts the execution of the script for a number of miliseconds.

Property "ms" should contain the number of milliseconds the script should pause.

Suppresses all error dialogs and user dialogs.

All feedback to the user in the form of message dialogs that halt the execution of the script are suppressed.

Tip: Use this action to be sure that a script will always run to completion. Test the script thoroughly before using this action.

Note: The Show Errors and Dialogs action will re-enable dialogs again.

Enables all error dialogs and user dialogs after a Suppress Errors and Dialogs action.

Note: This is the case by default, i.e. without using this action.
The Suppress Errors and Dialogs action will disable error and user dialogs.

Fills the "Last Error variable" with a description of the last encountered error.

Tip: When the Supress Errors & Dialogs action is used,  this action can be used to catch and handle script errors.

Stops the execution of the script.

Typically used when using the Label action or when the script encounters a condition it should stop at all times like an error.

Pauses the execution of the script when running to continue in step mode.

Tip: Inspect the content of variables and sources when paused. You can resume or step the script after this action line with the menu bar controls.

Note: In a compiled script this action is ignored.

Fills the "Result Text variable" with the directory path where the current script is located.

Use this action when files are needed and placed in the same folder as the script or compiled script.

Tip: Use the Get System Folder action to get specific paths to folders like the Temp folder or My Documents.

Shows or hides up Djuggler's internal web viewer.

Shows or hides up Djuggler's internal grid viewer.

Shows or hides up Djuggler's internal text viewer.

When a script is loaded that is created by a more recent version of Djuggler a missing action statement will replace all unkown actions from the new Djuggler version.

Displays a text message to the user in a message box.

Presents the user with an input box. The "Prompt" variable has the prompt text. The "Answer" variable will contain the answer the user has typed in in the input box.

Presents the user with an dialog for Yes or No. The "Prompt" variable has the prompt text. The "Answer" variable will contain the answer Yes or No.

Tip: When using a If action to verify the "Answer" variable, compare to 'Yes' or 'No' (case sensitive).

Shows an open file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and filename.

Shows a save file dialog asking the user to choose a file.

The file will be passed on to the "Answer" variable and contains the fully qualified path with directory and filename.

Shows a dialog asking the user to choose a directory.

The directory path will be passed on to the "Answer" variable. It will contain a fully qualified directory, trailed by a backslash ("\").

Replaces the current content of variable "Variable" with the content in variable "Content".

Adds to the content in variable "Variable".

Adding is done differently for each variable type. If the variable is text, the content is appended to the current text in "Variable". If the variable is a number, the content is added arithmetically. In case of a date, the dates are added to a new date.

Subtracts from the content in variable "Variable".

Subtracts are done differently for each variable type. If the variable is text, the content is subtracted from the current text in "Variable". If the variable is a number, the content is subtracted arithmetically. In case of a date, the dates are subtracted to a new date.

Copies the content of the Source to a Variable.

If the Source is a Web Page for example, the HTML source of the web page is copied to the Variable.

Copies the content of the Variable to the Source.

If the Source is a Text File for example, current content of Variable would be copied to the Text File.

Returns the date part from a Date variable as a Text variable.

Note: The date format is based on the computer locale settings. Use the Parse Date variable action to convert independent from locale settings.

Returns the time part from a Date variable as a Text variable.

Note: The time format is based on the computer locale settings. Use the Parse Date variable action to convert independent from locale settings.

Returns a random number within a certain range.
If you set the range minimum to 1 and the maximum to 5, the action chooses a number randomly between 1 and 5.

Returns a Globally Unique Identifier as a text variable.

Tip: Guid's are typically used to create a unique id in a Data Grid for example.

Returns the day, month, year, hour, minutes and seconds as text variables from a date variable.

Tip: Use this action to convert a date variable independent of the computer locale.

This action can be used for mathematical calculations.

A few examples of valid expressions: "4+2", "sqrt(9)", "(4+2)/sqrt(9)".

Within the expression, you can use Djuggler variables by putting the variable name between square brackets. For example, if you have a number variable in your script named "Number1", you could make the expression "(4+2)/sqrt([Number1])".
The result of the expression is returned in the Result variable.

Operators that can be used:
+ : Addition
- : Subtraction
* : Multiplication
/ : Division
^ : Exponential (only positive numbers for the base)
( : Open parenthesis
) : Close parenthesis


Functions that can be used:
ABS (Range: -1e4932..1e4932)
ATAN (Range: -1e4932..1e4932)
COS (Range: -1e18..1e18)
EXP (Range: -11356..11356)
LN (Range: 0..1e4932)
ROUND (Range: -1e9..1e9)
SIN (Range: -1e18..1e18)
SQRT (Range: 0..1e4932)
SQR (Range: -1e2446..1e2446)
TRUNC (Range: -1e9..1e9)

Reads a Text file and places the content of each text line as a collection item in the "List variable".

Stores the items of the List in a text file. Each item is stored on a new line.

Adds an item to a List. New items will be placed at the end of the list.

Removes an item from a List variable.

Note: If there are more than one matches to the item, only the first occurring item in the list is removed!

Removes duplicated items from a List.

After executing this action, only unique items remain.

Removes all the items from a List.

After executing this action, the list will be empty.

Sort the items in a List.

You can sort the list ascending or descending, depending on the value you set in the "Direction" property.

Opens a "Text file" and places the content in the Text source variable.

A Text File source can be manipulated by Text Manipulation and Source Text Manipulation actions.

Saves a "Text File" source to a file.

A Text File source can be manipulated by Text Manipulation and Source Text Manipulation actions.

Appends a line to a text file.

The property "Text" is written to the end of the file. This action works directly on the file, there is no need to use the Open Text File first.

Note: Use the Append to Text File action to append text without a new line.

Appends the property "Text" to a text file.

The text is appended to the end of the file without a new line. This action works directly on the file, there is no need to use the Open Text File first.

Create a new "XML Document" in memory that can be saved later.

Provide a document source as reference to the XML document. If the "Root Name" property is set, the document root node will have that name, else "xml" will be used. If you provide a XML node variable in the "Result Node" property it can be used as a reference node to do further processing, like adding a node to the root node.

Opens an XML Document from a file.

The XML file is opened into the "XML Document source".

Saves an XML Document source to a file.

Returns the root of the "XML document" in a XML node variable.

Tip: Use the found root node in combination with the Add XML node action to add a new node under the root node for example.

Loops nodes in the xml tree from a specific start point. Optionally returns only nodes with a specific name or path.

Tip: The "Look for" property can be a Node name or (partial) Node path. Path notation is with forward slashes like: 'books/book'.

If the complete XML tree is to be looped, use the root node as starting node.

When "Look for" is defined as 'book' the loop will pass all nodes named 'book' to the "Result Node" variable, regardless of where they are from the starting point in the tree.
When "Look for" is defined as 'books/book' all "book" nodes will be returned that reside directly under a parent node named 'books'.

Finds a single XML node in the xml tree from a specific start point based on Node name or Node path.

The "Look for" property can be a Node name or (partial) Node path. Path notation is with forward slashes like: 'books/book'.

Tip: If the complete XML tree is to be looped, use the root node as starting node.

When "Look for" is defined as 'book' the loop will pass all nodes named 'book' to the "Result Node" variable, regardless of where they are from the starting point in the tree.
When "Look for" is defined as 'books/book' all "book" nodes will be returned that reside directly under a parent node named 'books'.

Returns the value of a XML node in a text variable.

Sets the value of an XML node, optionally as CDATA.

Note: When setting a value in default format special characters as '>' will be translated automatically.

Returns the value of a child node from an XML parent node in a text variable.

Tip: Use this action in combination with the Find XML node to set the parent node for example.

Sets the value of a child node from a parent XML node, optionally in CDATA.

Returns an attribute value of a XML node.

Sets an attribute value of a XML node.

Adds a new XML node to a parent XML node and returns the added node in a XML node variable.

Deletes an XML node.

Opens a web page and puts the HTML content in the Web Page source variable.

Note: The source obtained by the Open Web Page action is the DOM source and differs slightly from the HTML as obtained via the 'View Source' option in IE or other browsers.

Tip: To inspect the HTML source, use the Djuggler's Browse Viewer from the menu (F3).

Opens a web page and puts the HTML source as in the IE 'view source' option in the content in the Web Page source variable.

Note: This is not the DOM source as shown in the Djuggler Web Viewer. This is the source as typed by the web designer.

Records and automates an entire "manual" browse action, complete with typed urls, mouse clicks and fill in boxes. Typically used for a logon procedure on a web site.

The Web Viewer is launched when using the Recorder. You can use this browser just as you would use any other Internet Browser. Your browse action is recorded by clicking the Record button, doing your browse actions, clicking the Stop button and then Close. Your manual browsing is now recorded. When running a script, the exact sequence of events is replayed on the Web Page variable in this action. Note that this browsing is done from the current page in the Web Page variable.

Downloads a file, document, image or web page and saves it to disk.

Note 1: Any existing files will be overwritten without warning by this action.
Note 2: When a non existing file is specified, the browser source returned by the server will be downloaded as document, typically 404 information. Use the Get URL status code to verify if a file really exists.

Returns the status code of a URL. For example 404 if the page can not be found.

The "Is URL valid" property can be used to verify if a URL has a valid syntax. Yes or No is returned.

Reads the next hyperlink ('A' tag) in a Web Browser source and returns the "URL" and "Title" of the hyperlink.

Note: This action moves the source cursor position in the Web Page source like the Source Text Manipulation actions.

Tip: Use this action in a loop to collect all hyperlinks in a web page.

Searches for a text in a Web Page source and returns the nearest URL in a variable.

Tip: Use this action to find a typical 'Next page' link by searching for the "Text" 'Next'.

Searches a "Web Page" source for the next image and returns it as "Image" variable.

The Save Image action can save the image variable. The name of the found image is returned in the "Image Name" variable.

Note: This action moves the source cursor position in the Web Page source like the Source Text Manipulation actions.

Tip: Use this action in a loop to collect all images in a web page.

Save an Image variable to disk. Typically used in combination with the Read Next Image action.

Note: When the filename is not specified, the filename from the image is used.

Collects all data from a HTML table to a "Data Grid" source.

The "Table Number" variable to indicates the HTML table to use. For example Table Number 3 will collect data from the thrid <TABLE> tag found in the HTML.

Tip: Use the Web Page viewer (F3) to inspect the table number in a web page.

Reads the content from a HTML tag.

The position of the cursor in the Source is remembered. This means that by calling this action multiple times you can read subsequent tags to get their content.

The action looks for the tag specified in the Tag property. If you set Attribute Name and Value, only tags are matched where the tag attribute contain the set value.

For example, say you want to read the content of a html tag specified by the following html: "<TD class='myclass'>some content here...</TD>". Fill in "TD" as Tag, "class" as Attribute and "myclass" as Value. The action will now seek through the html and return the content of the first found tag in the Content property.

Get the web page's source after a delay without reloading the Web Page.

Use this action to obtain any changed HTML source due to dynamic reloading of (part of) the web page. This is sometimes necessary because while the browser appears to be ready (the page is in fact fully loaded), after this event dynamic code (aspx reloads for example) change the HTML. This action is especially handy after you have just run a web macro on a dynamic page, for example changing a selection in a dropdown or marking a checkbox.

Fills a field in a form on a web page. Typically used for form automation, like a login to a web site.

Example: If the form element looks like "<INPUT Name="usr_name">".
Set the name to the value "John", set Field Name to "usr_name" and Value to John.

Tip: The Djuggler Web Viewer can inspect the tag information needed for this action.

Executes JavaScript in a Web Page source. This can either be an existing JavaScript function found in the HTML source or JavaScript in the action property.

Tip: The Execute JavaScript is used in combination with the Refresh Browser Source action to handle AJAX enabled web sites.
See the demo scripts.

Performs a mouse click on a certain element in an HTML page. Typically used to click on a submit button programmatically.

Tip: The Djuggler Web Viewer can inspect the tag information needed for this action.

Removes all HTML tags from a text or variable with only the actual readable text as result. Typically used to clean out HTML tags from a Copy Text Between action.

Tip: To remove all tags from a HTML source, transfer a web page source content to a text variable by using the Source Text to Variable action.

Completes all links (href's) in a web page source's content. If you are about to extract links from a web page, it is handy to use this action before any extraction takes places. This ensures that all links you grab will be complete.

Example: A link like "./support/index.htm"; would be translated into something like "http://www.mysite.com//support/index.htm".

Tip: Calling Open Web Page after a Complete Page Links action refills the web page source, so to complete all links in the new page, you would have to call Complete Page Links again.

Copy the value of a Data Grid cell into a variable.

Note: Rows and Column numbers start at "1".

Use the Row and Column variables to specify the cell. 
For example, using Row:2 and Column:3 would get the content from the cell located at the second horizontal row and the third vertical column.

Copy the value of a variable into a Data Grid cell.

Note: Rows and Column numbers start at "1".

Use the Row and Column variables to specify the cell.
For example, using Row:2 and Column:3 would set the content in the cell located at the second horizontal row and the third vertical column.

Stores one or more variables into a Data Grid source. The variable name is used as field name.
If a field name already exists, the corresponding column is used to store the variable's data. If the field name is new, a new data column is used.

Clears the Data Grid.

Deletes row(s) from a Data Grid. The Row variable determines which row(s) to delete.

Example: "1,2" deletes rows 1 and 2 ("2,1" would be incorrect, because 1 is lower than 2)

The Row variable indicates the row number that must be deleted. Filling in "2" means the second row in the Data Grid will be deleted. You can delete multiple rows.
For example, use as Row value "1-4" will delete row 1 through 4 in the Data Grid. Using "1,2,3,4" as Row value would have done the exact same thing. However, always keep numbers in succession, from low to high. Use comma's to separate row numbers, dashes (-) to indicate a row range. Do not use spaces.

Correct value: "1,2,4-6" deletes rows 1, 2, 4, 5 and 6.
Correct value: "1-2,7-8" deletes rows 1, 2, 7 and 8.

Deletes column(s) from a Data Grid. The "Column" variable determines which column(s) to delete.

Example: "1,2" deletes columns 1 and 2 ("2,1" would be incorrect, because 1 is lower than 2)

Filling in "2" means the second column in the Data Grid will be deleted. You can delete multiple columns.
For example, use as Column value "1-4" will delete column 1 through 4 in the Data Grid. Using "1,2,3,4" as Column value would have done the exact same thing. However, always keep numbers in succession, from low to high. Use comma's to separate row numbers, dashes (-) to indicate a row range. Do not use spaces.

Correct value: "1,2,4-6" deletes rows 1, 2, 4, 5 and 6.6.
Correct value: "1-2,7-8" deletes rows 1, 2, 7 and 8.

Appends one Data Grid to the other. The data is appended at the end of the Data Grid. The "Data Grid to append" variable indicates the grid that gets appended to the "Data Grid" variable.

Open a connection to a Microsoft SQL database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a MySQL database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a Oracle database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a Informix database.
 

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Open a connection to a DB2 database.

Use the SQL Query Direct action for direct SQL update and insert statements, or use the SQL Record Set actions to loop through a record set after a SQL select statement.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

When connecting to a database to run "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Close a connection to a SQL database.

Note: When a SQL Record Set is being used, the close action automatically applies changes made to the current record set to the database.

Execute a SQL query directly without returning in a record set in memory.

Note: Changes made by the query are reflected in the database immediately.

Tip: SQL Query Direct is typically used for updating a database or adding new records. 

When connecting to a database to run a "SQL Query Direct" action, use the following basic structure:

... do actions...
Connect
SQL Query Direct
Disconnect

Always first use a "Connect" action to connect to the server. Next you run a "SQL Query Direct" action. Use "Disconnect" action as the last action to close the database connection.

Execute a SQL query and returns a record set in memory linked to the database connection.
Record sets can be looped with Loop Records. Field values can be set or read with Get and Set Field actions.

Note: Record sets are commited back to the database with the Commit Changes action or on the Disconnect.

When using a record set, use the following basic structure:

Connect
SQL Query for Records
... do actions like Loop Data Grid Rows...
Disconnect

First use the Connect action to connect to the server. Next run a SQL Query for Records and create a result set of records in memory, linked to the SQL database connection. Next use actions like Get Field or Delete Record.
Changes in the records set will not be saved to the database until Commit Changes is used or the the Disconnect action is called.

Append a record to the end of the current record set.
The appended record becomes the active, current record, and can directly be used with a Set Field action for example.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

Remove the active, current record from the record set.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

Get the value of a field from the active, current record in the record set and copy it to a variable.
Use the "Field Name or Column number" property to indicate which field in the record is to be used.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

Set the value of a field in the active, current record in the record.
Use the "Field Name or Column number" property to indicate which field in the record is to be used.

Note: Changes will be applied to the database after a Disconnect or Commit Changes action, or after a Loop Records has finished.

Apply any changes to the active record set into the database. Use this action to force a commit to the database.

Note: When a Loop Records has finished or Disconnect action is invoked, changes to the database will be commited automatically.

Move the current record pointer to the first record in the active record set.

Move the current record pointer to the last record in the active record set.

Move the current record pointer to the next record in the active record set.

If the last record is reached, the "Last Record Reached" variable will be set to "Yes".

Tip: Use the "Last Record Reached" variable to exit a simple Loop action when not using the Loop Records action.

Move the current record pointer to the previous record in the active record set.

If the first record is reached, the "First Record Reached" variable will be set to "Yes".

Tip: Use the "First Record Reached" variable to exit a simple Loop action when not using the Loop Records action.

Copy the complete content of the active record set into a Data Grid source.
 

Finds a text string in the content of source and sets the source cursor to a new position.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Find Text in Source action, like Copy Text from Source and Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Read from the current cursor position until the text in "Read Until" property is found. The read text is stored in the assigned "Found Text" variable. If no text was not found the Found Text will be empty.

Tip: This actions supports one or more asterix ('*') wildcard for a copy like read until '<TR*><TABLE*>'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Copy Text from Source action, like Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Copy text between a "From Text" and a "To Text" property from the current cursor position in a source and returns the copied text in a variable.
 
Tip: This actions supports one or more asterix ('*') wildcard for a copy like from '<TR*>*Name:' to '</TR>'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Copy Text from Source Between action, like Copy Text from Source and Insert Text in Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action. This is typically used when collecting a structure of data from HTML table in a loop action for example.

Inserts a text at the current cursor position in the source.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Insert Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Replace all occurenses of a text from the current cursor position in the source with a new text.

Tip: This actions supports one or more asterix ('*') wildcard for a copy like from '<TR*>*Name:' to '</TR>'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Replace Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Matches a regular expression in a source from the current cursor position. The "Mached Text" is returned in a variable.
Tip: More info on regular expressions can be found at: http://www.regular-expressions.info

Note: Source Text Manipulation actions always keep an internal cursor position in the source for reference, while Text Manipulation actions don't have a cursor position.

The Match Text in Source action, like Copy Text from Source are Source Text Manipulation actions. Meaning they operate on a source with a cursor position, while normal Text Manipulation actions like Copy Text do also work with sources but without a cursor position.
A cursor position in a source is remembered and used the next time you use a Source Text Manipulation action.

Find a text string in the content of source or variable and returns the position of the found text as a number variable. If the text was not found, "Result Position" is set to 0.

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Copy text from a source or variable, starting at "Start Position" and copying until the "End Position" is reached. The copied text is returned in the "Copied Text".

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Copy text from a source or variable between two strings. Text is copied from the "From Text" property value until "To Text" property value. The copied text is returned in the "Copied Text" property as variable.

Tip: This actions supports one or more asterix ('*') wildcard for a search text like '<TR*>*Name:'. Line breaks in a source must also be mached with '#13#' or by a wildcard '*'.

Insert a string in a source or variable at specific position.

A 'position' is the the index position of a character or string. Example: The 'q' in the string 'The quick brown fox' has a position 5. The first character is always 1.

Replace a single or all occurrences of a text with another text in a source or variable.

Note: This text is case sensitive.

Tip: This action supports an '*' as wildcard.

Matches a regular expression in a variable or source. The "Mached Text" is returned in a variable.

Tip: More info on regular expressions can be found at: http://www.regular-expressions.info

Matches a regular expression in a variable or source and replaces all occurrences of the matches with another text.

Tip: More info on regular expressions can be found at: http://www.regular-expressions.info

This action convert text of a a format to another format.

Supported conversions are UTF-8 to ASCII and vise versa.
And special HTML characters to ASCII. For example '&nbsp' to a space.  

This action (fuzzy) compares one string to another and gives back a score how good the match is. Use this to decide how similar or dissimilar one string is compared to another. If you want to pick the best matching string from a list, use the Fuzzy Best Match action instead.

The action will compare a text string in the "Text1" property with a text string in the "Text2" property. It will provide a score as a result in the "Score" property. The Score is a measure of how much the two strings are alike. The Score depends on which algorithm you choose for comparison.

Algorithms: The algorithm determines how strings are compared to each other. Different algorithms have different applications, so it depends on the matching task you have which one is best for you.

DA1. Djuggler native fuzzy string comparison algorithm. In addition to comparing words, it also does a good job comparing "sentences" (strings of words). The lower the Score the better the match. A Score of -300 is a better match than a Score of -50 or 200. Score can be negative as well as positive. For example: compare "Nokia E66" with "Nokia E66" (Score:-300), "Nokia E65" (-279) and "Samsung Soul" (200). From these three strings, Nokia E66 is the best match, while Nokia E65 doesn't do bad either. Samsung Soul compares much worse to Nokia E66. Although not fool proof, negative scores can be considered good matches, while positive scores can be considered bad ones.

Levenshtein. The Levenshtein fuzzy string comparison algorithm. This algorithm calculates the difference between two strings (edit distance). The more differences are found, the higher the Score. A perfect match gets a Score of 0; less perfect matches get a higher score. Score is a positive number starting at zero.

Jaro-Winkler. The Jaro-Winkler fuzzy string comparison algorithm. This algorithm calculates the similarity between two strings. The more similarities are found, the higher the Score. A perfect match gets a Score of 1; the lowest score is 0. Score is a positive number between zero and one. 

Replacement List: you can provide a list variable here containing string replacements. These replacements are performed before the comparison is done. This allows you to correct for different spellings of a word (for example "3rd" and "third") before you compare strings, enhancing the match score. Each replacement is a separate item in the list, separated by an "=". To replace "3rd" with "third", add an item "3rd=third" to the list. 
 
 

This action finds the best (fuzzy) match of a string in a list of strings. The best matching string in the list is returned.

The action will compare a text string in the "Text" property with a list of strings in the "List" property. It will return the string from the list that best matches the stringin the Text property. The Score is a measure of how much the two strings are alike. The score depends on which algorithm you choose for comparison.

Algorithms: The algorithm determines how strings are compared to each other. Different algorithms have different applications, so it depends on the matching task you have which one is best for you.

DA1. Djuggler native fuzzy string comparison algorithm. In addition to comparing words, it also does a good job comparing "sentences" (strings of words). The lower the Score the better the match. A Score of -300 is a better match than a Score of -50 or 200. Score can be negative as well as positive. For example: compare "Nokia E66" with "Nokia E66" (Score:-300), "Nokia E65" (-279) and "Samsung Soul" (200). From these three strings, Nokia E66 is the best match, while Nokia E65 doesn't do bad either. Samsung Soul compares much worse to Nokia E66. Although not fool proof, negative scores can be considered good matches, while positive scores can be considered bad ones.

Levenshtein. The Levenshtein fuzzy string comparison algorithm. This algorithm calculates the difference between two strings (edit distance). The more differences are found, the higher the Score. A perfect match gets a Score of 0; less perfect matches get a higher score. Score is a positive number starting at zero.

Jaro-Winkler. The Jaro-Winkler fuzzy string comparison algorithm. This algorithm calculates the similarity between two strings. The more similarities are found, the higher the Score. A perfect match gets a Score of 1; the lowest score is 0. Score is a positive number between zero and one. 

Replacement List: you can provide a list variable here containing string replacements. These replacements are performed before the comparison is done. This allows you to correct for different spellings of a word (for example "3rd" and "third") before you compare strings, enhancing the match score. Each replacement is a separate item in the list, separated by an "=". To replace "3rd" with "third", add an item "3rd=third" to the list.

Splits a text variable and returns the right part of the split text.

Example: On the text 'abcdef' with 'cd' as "Split Characters"; 'ef' will be returned as "Split Text".

Note: When the "Split Characters" are not found the complete content of "Text" will be returned in "Split Text".

Splits a text variable and returns the left part of the split text.

Example: On the text 'abcdef' with 'cd' as "Split Characters"; 'ab' will be returned as "Split Text".

Note: When the "Split Characters" are not found the complete content of "Text" will be returned in "Split Text".

Trims leading and trailing spaces of the content in a text variable.

Converts all characters in the content of a text variable to upper case.

Converts all characters in the content of a text variable to lower case.

Converts the first character in the content of a text variable to upper case.

Strips all HTML tags from the content of a text variable.

Example: '<B>Hello <I>World</I></B>' would become 'Hello World'.

Imports an Excel file and puts the contents in a Data Grid source.

Note: The first Excel sheet is always used for import.

This action supports Excel 97, 2000 and 2003 formats.
For Excel 2007 format, please see the separate action for this format.

Imports an Excel file from MS Office 2007 and puts the contents in a Data Grid source.

This action only supports Excel 2007 format, please see the separate actions for other Excel formats.

Import an Access file and put the contents in a Data Grid source.

This action supports Access 97, 2000 and 2003 formats.

Import a DBF file and put the contents in a Data Grid source.

This action supports DBF and FoxPro formats.

Import an Comma Separated Values file and put the contents in a Data Grid source.

This action supports CSV with comma, semi-colon and tab as separators.

Export data from a Data Grid source to an Excel file.

The exported file is readable in Excel versions 97, 2000 and 2003.

Export data from a Data Grid source to an Excel file in Excel format.

The exported file is readable in Excel version 2007.

Export data from a Data Grid source to an Access file in Excel format.

The exported file is readable in Access versions 97, 2000 and 2003.

Export data from a Data Grid source to a DBF file.

Export a Data Grid source to a Comma Separated Values file.

This action supports CSV files with comma, semi-colon and tab as separators.

Export a Data Grid source to SQL Script text file.

Copies one or more files to another location.

Tip: Indicate multiple files by using wildcards like: c:\myfiles\*.*.

Moves one or more files to another location.

Tip: Indicate multiple files by using wildcards like: c:\myfiles\*.*.

Change the name of a file or folder.

Deletes a file.

Create a new folder.

Tip: You can create several nested folders at once, i.e. "c:\folder1\folder2" creates the full path indicated including 'folder1' if it did not exist already.

Copies a folder including files to another location.

Moves a folder including files to another location.

Deletes an existing folder.

Retrieves various information about a given file, like: size, creation date, etc.

Retrieves various information about a the path of a given file, like drive, file extension, etc.

Deliver mail directly at the receiver's mail server without relaying through an SMTP host.

Tip: Read the more help for embedding images in HTML email.

The minimum properties required to send an e-mail are the "To", "From", "Subject" and "Body" properties.

The "To" property can only be a single email address, valid notations are 'john.doe@someplace.com' or 'John <john.doe@someplace.com>' or '"John Doe" <john.doe@someplace.com>'.

The "Body" property is the plain text part of the message, this can be either plain text or a filename that should be loaded as the body text.

The "HTML Body" property is the HTML part of the message that will be included and can either be HTML text or a local filename.

If the HTML contains pictures (GIF, JPG or PNG) with a local reference, they will be embedded inline.
Example: '<img scr="c:\mypicture.jpg">' will be embedded inline because is has a local reference; '<img scr="http://somedomain/mypicture.jpg">' will NOT be embedded inline.

The "Attachments" property is a comma separated list of local filenames, e.g. 'c:\myfile.doc, c:\myfile2.txt'.

If the "DNS" property is given, that dns is used to auto resolve the mx records, otherwise the first dns from the local system will be used.

The "Result" property contains the result of the action, a message with a specific error or success message.

Send Mail by SMTP will send a plain text or html e-mail via an SMTP host.

Tip: Read the more help for embedding images in HTML email.

The "To", "CC" and "BCC" properties can be a single email address or multiple e-mail addresses separated by a comma, valid notations are 'john.doe@someplace.com, jane.doe@someplace.com' or 'John <john.doe@someplace.com>' or  '"John Doe" <john.doe@someplace.com>, "Jane Doe" <jane.doe@someplace.com>'.

The "Body" property is the plain text part of the message, this can be either plain text or a filename that should be loaded as the body text.

The "HTML Body" property is the HTML part of the message that will be included and can either be HTML text or a local filename.

If the HTML contains pictures (GIF, JPG or PNG) with a local reference, they will be embedded inline.
Example: '<img scr="c:\mypicture.jpg">' will be embedded inline because is has a local reference; '<img scr="http://somedomain/mypicture.jpg">' will NOT be embedded inline.

The "Attachments" property is a comma separated list of local filenames, e.g. 'c:\myfile.doc, c:\myfile2.txt'.

If the "DNS" property is given, that dns is used to auto resolve the mx records, otherwise the first dns from the local system will be used.

The "Result" property contains the result of the action, a message with a specific error or success message.

Optionally a specific SMTP "Port", "Username" and "Password" can be specified for the SMTP connection.

Send a raw e-mail message file to a smtp host.

A raw e-mail message file is a text file that contains headers, addresses and content for an e-mail message.
These files are typically found in message queues of mail servers and used by programs as the Microsoft SMTP service.

A simple and minimal raw message file may look like:

TO: john.doe@someplace.com
FROM: jane.doe@someplace.com
SUBJECT: message from jane

Hello John,
Bye Jane.
 

This action executes a shell command.

For example, using 'notepad.exe' as "Command" property value will bring up Windows notepad editor.

Note: Use quotes when filenames or parameters contain spaces.

This action allows you to run a DOS application and catch its output in a variable.

Example: 'ipconfig.exe /all' as "Command line" property value will catch ip information output in a variable.

Note: Use quotes when filenames or parameters contain spaces.

A Djuggler compiled script can be called with parameters. This action reads a parameter and assigns it to a text variable to be used in the script.

Example: Set "Param name" to '/log' and call the compiled script as 'myscript.exe /log=c:\temp\mylogfile.txt'.

Tip: Use the "Default value" property value to test the parameter when not running as a compiled script.

Returns the path to the special Windows folders, like the Temp folder or My Documents (Personal folder), etc as a text variable.

Returns various system information, like Computer name, User name, IP Address, etc as a text variable.

Returns the current date and time in a variable.

Tip: Use the "Date from Date variable to Text" or "Time from Date variable to Text" or "Parse Date variable" actions in the 'Variables' group to convert dates and times.

Returns a registry value as a text variable.