Overview
New Project Wizard
Export Wizard
Settings
Purchase and Support
Script Editor
Script Editor allows you to create or edit your own script for transforming text data. You can use two programming languages: Microsoft JScript and Microsoft Visual Basic (VBScript).
You can switch between the languages using the "Language" drop-down list.
You can create a new script by clicking the "New" button.
You can click the "Parse" button to ensure the script does not generate any errors. If the script is successfully parsed, you will get the following message: "The script is parsed successfully".
You can open a previously saved script from a file by clicking the "Open..." button and save the current script to a file by clicking the "Save..." button.
You can select a function in the "Functions" list box and click the "Insert" button to insert the function code into the text box at the position of the cursor.
You can test the script by entering a string into the "String" field label and clicking the "Run Test" button. You will see the result of the test in the "Result" field.
You can use a script template to quickly create a script. To make a script out of a template, select the corresponding template from the "Script Templates" list, click the "Open" button, specify all parameters in the "Script Parameters" window and click "OK". The program will generate the corresponding script and show its result at the bottom of the window.
Script Functions
| Function Name | Description & Parameters |
|---|---|
| Add_String_At_The_Beginning |
Adds a specified string to the beginning of the input string.
Parameters:
• strInput: The original string • strPrefix: The string to add at the beginning |
| Add_String_To_The_End |
Appends a specified string to the end of the input string.
Parameters:
• strInput: The original string • strSuffix: The string to add at the end |
| Download_URL |
Downloads content from a specified URL.
Parameters:
• url: The URL to download content from |
| Extract_Email_Addresses |
Extracts email addresses from a string using regular expression pattern matching.
Parameters:
• strInput: The string to search for email addresses • Returns: Array of email addresses found |
| Extract_Phone_Numbers |
Extracts phone numbers from a string using regular expression pattern matching.
Parameters:
• strInput: The string to search for phone numbers • Returns: Array of phone numbers found |
| Left_String |
Extracts substring from the first character up to the specified search string.
Parameters:
• strInput: The original string • strSearchFor: The delimiter string • strReverseSearch: Search direction 0 = search from beginning 1 = search from end |
| Replace_String |
Replaces all occurrences of a substring with another string.
Parameters:
• strInput: The original string • strFindWhat: Substring to find • strReplaceWith: Replacement string |
| Replace_String_RegEx |
Replaces strings matching a regular expression pattern.
Parameters:
• strInput: The original string • pattern: Regular expression pattern • replacement: Replacement string |
| Right_String |
Extracts substring from the specified search string to the end.
Parameters:
• strInput: The original string • strSearchFor: The delimiter string • strReverseSearch: Search direction 0 = search from beginning 1 = search from end |
| Split_String |
Extracts a specific item from a delimited string array.
Parameters:
• strInput: The original string • strDelimiter: Character(s) to split by • strItemIndex: Index of item to extract (0-based) |
| Strip_HTML_Tags |
Removes all HTML tags from a string.
Parameters:
• strInput: The HTML string to clean |
| Sub_String |
Extracts substring between two specified delimiters.
Parameters:
• strInput: The original string • strStartSearchFor: Starting delimiter • strEndSearchFor: Ending delimiter • strReverseSearch: Search direction 0 = search from beginning 1 = search from end |
| Sub_String_RegEx |
Extracts substring using regular expression pattern.
Parameters:
• strInput: The original string • strPattern: Regular expression pattern |
| Trim_String |
Removes specified characters from both ends of a string.
Parameters:
• strInput: The original string • strSearchFor: Characters to remove |
Available Constants
- \r\n - the new line character used in scripts written in Javascript.