Compare strings in python like the sql “like” (with “%” and “_”)

Question

I have a rundown (list) in python for certain strings, and I want to know which thing in the rundown resembles "A1_8301". This "_" implies that can be any char. Is there a snappy method to do that?

On the off chance that I was utilizing SQL, I simply type something like "where x like "A1_8301"

Thank you

Answer 1

import fnmatch

string_list = ["A1_8301", "B2_1234", "C3_5678"]

matched_items = [item for item in string_list if fnmatch.fnmatchcase(item, 'A1_8301')]

print(matched_items)

Output:

['A1_8301']

In the given example, we import the fnmatch module, which provides functionality for pattern matching akin to the "LIKE" operator in SQL. By utilizing the fnmatch.fnmatchcase() function, we can check if each item in the string_list matches the pattern 'A1_8301'. When a match is found, fnmatch.fnmatchcase() returns True. By employing a list comprehension, we filter the items that satisfy the pattern condition and store them in the matched_items list.

Using the fnmatch module in this manner enables you to easily perform pattern matching in Python, allowing you to locate strings that resemble a specific pattern within a list. The module handles wildcards such as "_", providing a concise and efficient method for pattern matching tasks.

Answer 2

You can use Regular expression, check the below code:

import re

pattern = re.compile(r'^A1.8301$')

matches = [x for x in yourlist if pattern.match(x)]

This delivers a list of components that match your prerequisites.

• The ^ and $ anchors are needed to prevent substring matches; BA1k8301-42 should not match, for example. The re.match() call will only match at the start of the tested string, but using ^ makes this a little more explicit and mirrors the $ for the end-of-string anchor nicely.
• The _ in a SQL like is translated to ., meaning match one character.

Interested to learn python in detail? Come and Join the python course.

Answer 3

Yes, in Python, you can use the fnmatch module to perform pattern matching similar to the "LIKE" operator in SQL. The fnmatch module provides a function called fnmatchcase that allows you to match strings using Unix shell-style wildcards.

Here's an example that demonstrates how you can use fnmatchcase to find a string similar to "A1_8301" in a list of strings:

import fnmatch

string_list = ["A1_8301", "B2_1234", "C3_5678"]

matched_items = [item for item in string_list if fnmatch.fnmatchcase(item, 'A1_8301')]

print(matched_items)

Output:

['A1_8301']

In the example above, the fnmatch.fnmatchcase(item, 'A1_8301') statement checks if each item in the string_list matches the pattern 'A1_8301'. The fnmatchcase function returns True if there is a match and False otherwise. The list comprehension filters the items that match the pattern, and the result is stored in the matched_items list.

Using the fnmatch module, you can perform pattern matching with wildcard characters like "_" in a concise and efficient manner.

Answer 4

import fnmatch

string_list = ["A1_8301", "B2_1234", "C3_5678"]

matched_items = [item for item in string_list if fnmatch.fnmatchcase(item, 'A1_8301')]

print(matched_items)

Output:

['A1_8301']

In the provided example, the fnmatch module is imported, which allows you to perform pattern matching similar to the "LIKE" operator in SQL. The fnmatch.fnmatchcase() function is used to check if each item in the string_list matches the pattern 'A1_8301'. The function returns True if there is a match and False otherwise. Using a list comprehension, the items that match the pattern are filtered and stored in the matched_items list.

By leveraging the fnmatch module, you can easily perform pattern matching in Python, including handling wildcards such as "_", providing a convenient and efficient way to find strings that resemble a specific pattern within a list.