1. IronXL
  2. IronXL Blog
  3. Excel Tools
  4. .NET Regex Tester

Published January 5, 2024

.NET Regex Tester (How it Works For Developers)

In the ever-evolving landscape of software development, robust tools that facilitate efficient coding practices are indispensable. Among these, regular expressions (regex) are crucial in string manipulation and pattern matching. In the .NET framework, developers can harness the power of .NET Regex Tester to streamline the process of crafting and testing regex patterns.

In this article, we embark on a journey to explore the functionalities and utilities offered by the .NET Regex Tester. Regex, a concise and powerful language for matching patterns in strings, is seamlessly integrated into the .NET framework. The .NET Regex Tester provides a dedicated environment for developers to fine-tune their regex patterns and test them against various input scenarios. This tool proves invaluable in debugging and refining regex expressions, ultimately leading to more efficient and error-resistant code.

This article delves into the capabilities of .NET Regex Tester, providing insights and examples into its usage and integration with IronXL, which is a powerful library for working with Excel files in .NET applications.

1. Introduction to .NET Regex Tester

.NET Regex Tester stands as a sophisticated web-based platform designed to streamline and elevate the intricacies of working with regular expressions within the .NET framework. This robust tool provides developers with an exceptionally user-friendly interface. It offers a seamless environment to input intricate regex patterns, rigorously test them against diverse sample strings, and intuitively visualize the corresponding matching results. Tailored specifically for the .NET flavor of regex, this tester guarantees flawless compatibility with the embedded regex engine in the .NET framework, thereby, ensuring precision and accuracy in pattern matching.

What sets the .NET Regex Tester apart is its array of features, including real-time matching capabilities and comprehensive match information, collectively converging to catalyze a substantial enhancement in the overall regex development workflow. In essence, this tool emerges as an indispensable ally for developers navigating the intricate landscape of regex, fostering efficiency, accuracy, and ease in the development process.

2. Code Example - Using .NET Regex Tester

To illustrate the practical application of .NET Regex Tester, let's consider a scenario where we need to extract email addresses from a given text. Below is a sample C# code snippet demonstrating how to use the .NET Regex Tester to achieve this:

using System;
using System.Text.RegularExpressions;
class Program
{
    static void Main()
    {
        string inputText = "Sample text with email addresses: user1@example.com, user2@example.net";
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";
        Regex regex = new Regex(pattern);
        MatchCollection matches = regex.Matches(inputText);
        foreach (Match match in matches)
        {
            Console.WriteLine($"Found email: {match.Value}");
        }
    }
}
using System;
using System.Text.RegularExpressions;
class Program
{
    static void Main()
    {
        string inputText = "Sample text with email addresses: user1@example.com, user2@example.net";
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";
        Regex regex = new Regex(pattern);
        MatchCollection matches = regex.Matches(inputText);
        foreach (Match match in matches)
        {
            Console.WriteLine($"Found email: {match.Value}");
        }
    }
}
Imports System
Imports System.Text.RegularExpressions
Friend Class Program
	Shared Sub Main()
		Dim inputText As String = "Sample text with email addresses: user1@example.com, user2@example.net"
		Dim pattern As String = "\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b"
		Dim regex As New Regex(pattern)
		Dim matches As MatchCollection = regex.Matches(inputText)
		For Each match As Match In matches
			Console.WriteLine($"Found email: {match.Value}")
		Next match
	End Sub
End Class
VB   C#

In this example, the regex pattern \b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b is used to match email addresses within the input text, not just the beginning character and end character but the entire string. The .NET Regex Tester allows developers to experiment with such patterns interactively, making the regex development process more intuitive.

2.1. Output Image

.NET Regex Tester (How it Works For Developers): Figure 1 - Console output from the code above

3. Introduction to IronXL

IronXL is a powerful and versatile .NET library designed to streamline the handling of Excel files within your applications. Whether you're working on a desktop, web, or mobile application, IronXL provides a robust set of tools and features to simplify the process of reading, writing, and manipulating Excel files.

Developed with the .NET framework in mind, IronXL seamlessly integrates into your C# or VB.NET projects, offering a straightforward and efficient solution for Excel-related tasks. Whether you're creating reports, importing data, or performing complex calculations, IronXL empowers developers with a comprehensive set of APIs and methods that make Excel file manipulation a breeze.

3.1. Install IronXL

To effortlessly install IronXL, utilize the NuGet Package Manager within Visual Studio. The specific package to install is named IronXL.Excel. Paste the below command in the Package Manager Console and press enter.

Install-Package IronXL.Excel

3.1. Code Example - Integrating IronXL with .NET Regex Tester

To showcase the synergy between .NET Regex Tester and IronXL, consider a scenario where you want to extract data from an Excel file based on a specific pattern. The following C# code snippet demonstrates how to use IronXL in conjunction with .NET Regex Tester:

using IronXL;
using System;
using System.Text.RegularExpressions;
class Program
{
    static void Main()
    {
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";
        // Load Excel file using IronXL
        WorkBook workbook = WorkBook.Load("datatable.xlsx");
        WorkSheet workSheet = workbook.WorkSheets[0];
        // Iterate through the sheets and cells to find any matching line
        foreach (var cell in workSheet["A2:A10"])
        {
            string cellValue = cell.Text;
            // Use .NET Regex Tester pattern to check and match case
            MatchCollection matches = Regex.Matches(cellValue, pattern);
            foreach (Match match in matches)
            {
                Console.WriteLine($"Found match in Excel at {cell.AddressString}: {match.Value}");
            }
        }
    }
}
using IronXL;
using System;
using System.Text.RegularExpressions;
class Program
{
    static void Main()
    {
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";
        // Load Excel file using IronXL
        WorkBook workbook = WorkBook.Load("datatable.xlsx");
        WorkSheet workSheet = workbook.WorkSheets[0];
        // Iterate through the sheets and cells to find any matching line
        foreach (var cell in workSheet["A2:A10"])
        {
            string cellValue = cell.Text;
            // Use .NET Regex Tester pattern to check and match case
            MatchCollection matches = Regex.Matches(cellValue, pattern);
            foreach (Match match in matches)
            {
                Console.WriteLine($"Found match in Excel at {cell.AddressString}: {match.Value}");
            }
        }
    }
}
Imports IronXL
Imports System
Imports System.Text.RegularExpressions
Friend Class Program
	Shared Sub Main()
		Dim pattern As String = "\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b"
		' Load Excel file using IronXL
		Dim workbook As WorkBook = WorkBook.Load("datatable.xlsx")
		Dim workSheet As WorkSheet = workbook.WorkSheets(0)
		' Iterate through the sheets and cells to find any matching line
		For Each cell In workSheet("A2:A10")
			Dim cellValue As String = cell.Text
			' Use .NET Regex Tester pattern to check and match case
			Dim matches As MatchCollection = Regex.Matches(cellValue, pattern)
			For Each match As Match In matches
				Console.WriteLine($"Found match in Excel at {cell.AddressString}: {match.Value}")
			Next match
		Next cell
	End Sub
End Class
VB   C#

This C# code utilizes the IronXL library to read data from an Excel file ("datatable.xlsx"). It defines a regular expression pattern for matching email addresses. The code then loads the Excel file, iterates through a specific range of cells (A2 to A10 in the first worksheet), extracts the text from each cell, and applies the defined regex pattern to find and print email addresses. For each match, the code outputs the cell address and the matched email value. The program is designed to demonstrate how to use IronXL to process Excel data and perform regular expression matching on cell values within a specified range.

Input Image

.NET Regex Tester (How it Works For Developers): Figure 2 - Inputted Excel file

Output Image

.NET Regex Tester (How it Works For Developers): Figure 3 - Console output from the above code

4. Conclusion

In conclusion, the .NET Regex Tester is an invaluable tool for developers working with regular expressions in the .NET framework. Its user-friendly interface and real-time matching capabilities enhance the efficiency of regex pattern development. Furthermore, when integrated with IronXL, developers can seamlessly extend their capabilities to work with Excel files, opening up new possibilities for data manipulation and analysis. By combining the strengths of these tools, developers can create robust applications with enhanced regex and Excel handling capabilities.

IronXL offers a free trial license for all its users It is great for testing and development purposes. To get the detailed tutorial on IronXL Read the Excel file and visit here. Here is the download link of IronXL from the NuGet Package Manager website.