.NET Regex Testerで正規表現パターンをテストする

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 the .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()
    {
        // Sample input text containing email addresses
        string inputText = "Sample text with email addresses: user1@example.com, user2@example.net";

        // Regex pattern to match email addresses
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";

        // Create a Regex object with the pattern
        Regex regex = new Regex(pattern);

        // Find matches of the pattern in the input text
        MatchCollection matches = regex.Matches(inputText);

        foreach (Match match in matches)
        {
            // Output each found email address
            Console.WriteLine($"Found email: {match.Value}");
        }
    }
}

using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
        // Sample input text containing email addresses
        string inputText = "Sample text with email addresses: user1@example.com, user2@example.net";

        // Regex pattern to match email addresses
        string pattern = @"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b";

        // Create a Regex object with the pattern
        Regex regex = new Regex(pattern);

        // Find matches of the pattern in the input text
        MatchCollection matches = regex.Matches(inputText);

        foreach (Match match in matches)
        {
            // Output each found email address
            Console.WriteLine($"Found email: {match.Value}");
        }
    }
}

Imports System
Imports System.Text.RegularExpressions

Friend Class Program
	Shared Sub Main()
		' Sample input text containing email addresses
		Dim inputText As String = "Sample text with email addresses: user1@example.com, user2@example.net"

		' Regex pattern to match email addresses
		Dim pattern As String = "\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,}\b"

		' Create a Regex object with the pattern
		Dim regex As New Regex(pattern)

		' Find matches of the pattern in the input text
		Dim matches As MatchCollection = regex.Matches(inputText)

		For Each match As Match In matches
			' Output each found email address
			Console.WriteLine($"Found email: {match.Value}")
		Next match
	End Sub
End Class

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. The .NET Regex Tester allows developers to experiment with such patterns interactively, making the regex development process more intuitive.

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.

Install-Package IronXL.Excel

using IronXL;
using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
        // Regex pattern to match email addresses
        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 specified range of cells and find matches
        foreach (var cell in workSheet["A2:A10"])
        {
            string cellValue = cell.Text;

            // Use regex to find matches within the cell text
            MatchCollection matches = Regex.Matches(cellValue, pattern);
            foreach (Match match in matches)
            {
                // Output each found match with its cell address
                Console.WriteLine($"Found match in Excel at {cell.AddressString}: {match.Value}");
            }
        }
    }
}

using IronXL;
using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
        // Regex pattern to match email addresses
        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 specified range of cells and find matches
        foreach (var cell in workSheet["A2:A10"])
        {
            string cellValue = cell.Text;

            // Use regex to find matches within the cell text
            MatchCollection matches = Regex.Matches(cellValue, pattern);
            foreach (Match match in matches)
            {
                // Output each found match with its cell address
                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()
		' Regex pattern to match email addresses
		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 specified range of cells and find matches
		For Each cell In workSheet("A2:A10")
			Dim cellValue As String = cell.Text

			' Use regex to find matches within the cell text
			Dim matches As MatchCollection = Regex.Matches(cellValue, pattern)
			For Each match As Match In matches
				' Output each found match with its cell address
				Console.WriteLine($"Found match in Excel at {cell.AddressString}: {match.Value}")
			Next match
		Next cell
	End Sub
End Class

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 to read the Excel file, visit here. Here is the download link of IronXL from the NuGet Package Manager website.