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.

You can add the following functions:

1. Add_String_At_The_Beginning - this function adds string at the beginning of a specific string.

2. Add_String_To_The_End - this function adds string to the end of a specific string.

3. Download _URL - this function downloads a specific URL.

4. Extract_Email_Addresses - this function extracts email addresses from a specific string using pattern matching (a regular expression).

5. Extract_Phone_Numbers - this function extracts phone numbers from a specific string using pattern matching (a regular expression).

6. Left_String - this function extracts the substring starting from the first character and ending with the substring specified in the strSearchFor parameter. The strReverseSearch parameter specifies the search order and can have one of the following values: 0 - the search begins from the beginning of string, 1 - the search begins from the end of string.

7. Replace_String - this function replaces the substring specified in the strFindWhat parameter with the substring specified in the second strReplaceWith parameter.

8. Replace_String_RegEx - this function replaces all strings that match a regular expression pattern with a specified replacement string. The pattern parameter specifies the pattern of an expression. The replacement is the replacement string.

9. Right_String - this function extracts the substring located between the substring specified in the strSearchFor parameter and the end of the string. The strReverseSearch parameter specifies the search order and can have one of the following values: 0 - the search begins from the beginning of string, 1 - the search begins from the end of string.

10. Split_String - this function extracts the substring with the index specified in the strItemIndex parameter from the array of strings resulting from dividing the initial string into substrings with the help of the delimiter specified in the strDelimiter parameter.

11. Strip_HTML_Tags - this function removes all HTML tags from a specific string.

12. Sub_String - this function extracts the substring located between the substring specified in the strStartSearchFor parameter and the substring specified in the strEndSearchFor parameter. The strReverseSearch parameter specifies the search order and can have one of the following values: 0 - the search begins from the beginning of string, 1 - the search begins from the end of string.

13. Sub_String_RegEx - this function extracts string from a specific string using regular expression (Regex). The "strPattern" parameter specifies the pattern of an expression.

14. Trim_String - this function removes character specified in the strSearchFor parameter on both sides of a string.

Available constants:

• \r\n - the new line character used in scripts written in Javascript.

• \r\n\r\n - double new line characters used in scripts written in Javascript.

• vbNewLine - the new line character used in scripts written in Basic.

• vbNewLine + vbNewLine - double new line characters used in scripts written in Basic.