Vbscript how many times a string occurs

Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here. Additionally you can specify the following Boolean flags that affect the search procedure: RegExp. Global - performs a global search for all occurrences of a pattern, RegExp.

IgnoreCase - searches regardless of the letter case and RegExp. MultiLine - performs a multi-line search. For a full description of how to use regular expressions, refer to the Introduction to Regular Expressions article in the MSDN library. The first sample demonstrates how to change a definite string using the replace method. Replace str, "Jack" Log. The second example shows how to replace a substring with alternative parts. The patterns of alternative parts are separated by pipe characters " ".

For instance in the sample below the "ht ml m " pattern matches both html and htm :. The HTM file is a text file with tags. Replace str, "hypertext markup language" Log. Furthermore, using regular expressions you can search for the text fragments that match the specified format. This operation can be useful, for example, when comparing two reports that contain the generation date. Replace str, "Some Date" Log.

A string can contain both uppercase and lowercase letters. The TestComplete aqString object and the native String object have methods that convert uppercase letters to lowercase and vice versa. They are: aqString. ToLower , aqString. ToLower str Log. Message LCase str ' Converting to upper case Log. ToUpper str Log. Message UCase str End Sub. Some scripting objects, generally, controls like ListBoxes, ComboBoxes and Memos, return information about their state or contents as string lists.

Individual data elements or items in this list are separated by commas, line breaks, carriage returns or some other delimiter characters. The GetListItem method retrieves the item with the given index, and ChangeListItem assigns a new value to the given item. The GetListLength method returns the total number of items in the string list. The symbol that is used as the separator between list items is defined by the ListSeparator property.

By default, the list separator is a pipe , but it can also be a comma, column, line break, carriage return, tabulation, and any other printable and non-printable character, or even several characters. Here is sample code that demonstrates how to work with the string lists returned by scripting objects. Text ' Post the memo contents to the log Log. Message UserForms. Text ' Restore the previous separator aqString. Switch To: SmartBear. Academy Open in new tab. Community Open in new tab. License Portal Open in new tab.

Store Open in new tab. Zephyr for Jira has a new name — Zephyr Squad. Learn more. Applies to TestComplete It contains the following sections: Basics Special characters Getting the string length Concatenating strings Comparing strings Accessing individual character of a string Searching for characters and substrings Getting a substring Splitting strings Removing extra spaces from a string Replacing characters and substrings Changing the letter case Working with string lists.

The following is an example of string: VBScript. Is there anyone? Description Character sequence Carriage return. Chr 13 -- or -- vbCr Line feed. On Unix platforms it is interpreted as new line. Chr 10 -- or -- vbLf A combination of carriage return and line feed.

On Windows platforms it is interpreted as new line. Either a line feed character or a combination of carriage return and line feed. Chr 12 -- or -- vbFormFeed Horizontal tab. Chr 9 -- or -- vbTab Vertical tab. Chr 11 -- or -- vbVerticalTab Special characters obtained by a function or constant should be joined to the string by concatenation : VBScript. The following code demonstrates both ways of obtaining the string length: VBScript.

This sample code shows how to make a string out of several substrings: VBScript. The code below demonstrates how to use both methods: VBScript. VBScript ' This helper function obtains the integer comparison result from the ' StrComp routine and returns a textual interpretation of the result.

If the specified substring was not found, the method returns VBScript. The sample code below demonstrates how to use these functions: VBScript. The first sample routine below uses a space character as a delimiter to extract words out of a string, and the second routine splits the string by line breaks: VBScript.

Here is an example of how to use this method: VBScript. The code below demonstrates how all of these methods are applied. Is this page helpful? Thank you! Highlight search results. Highlight search results Highlight search results. Searches for a substring within the given string. Use this method instead of the obsolete aqString. Returns the position of the first occurrence for one string within another.

Returns the position of an occurrence for one string within another, from the end of string. Returns the number of characters in a string or the number of bytes required to store a variable. Returns a string in which a specified substring has been replaced with another substring a specified number of times. Here a version using Regular Expressions so you can specify if the search needs to be case sensitive. For testpurpose I use the contents of the script itself as input. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Search number of times a string occurs in text file Ask Question. Asked 5 years, 4 months ago. Active 5 years, 4 months ago. Viewed 5k times. ReadAll objFile. Ansgar Wiechers k 23 23 gold badges silver badges bronze badges. Add a comment.

Active Oldest Votes. Close End With End Function. Sankar Karthi Sankar Karthi 2 2 silver badges 8 8 bronze badges. Victor Moraes Victor Moraes 1 1 gold badge 12 12 silver badges 27 27 bronze badges.