Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.
Regex - wild card search results help!
Does anyone know how I can tweak this string pattern to accept decimals? Right now we are able to search and find things but once there's a decimal in the string, the search cannot find it. It looks to be using Regex.
string pattern = @"(-[A-Za-z]*\d+[A-Za-z]*(
private SearchResponseData GetproductSearchResult(string searchText, string category = "")
{
//WILDCARD results if search term contains a Catalog Number
string pattern = @"(-[A-Za-z]*\d+[A-Za-z]*(-[A-Za-z]*\d+[A-Za-z]*)*)";
try
{
//Try strong Regex
string replacement = Regex.Replace(searchText, pattern, "$0*");
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = replacement };
}
catch (Exception ex)
{
//If syntax error, try weaker Regex
if (Regex.IsMatch(searchText, "-(\\d)*"))
{
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = searchText + "*" };
}
//Use search term as-is
else
{
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = searchText };
}
}
}
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Easy, but probably wrong:
string pattern = @"(-[A-Za-z.]*\d+[A-Za-z.]
Unless we can see the strings you're matching against and the desired result, I don't think we can help more.
HTH,
Dan
string pattern = @"(-[A-Za-z.]*\d+[A-Za-z.]
Unless we can see the strings you're matching against and the desired result, I don't think we can help more.
HTH,
Dan
Sorry - some items to search for are in this pattern that we cannot get it to appear
100-200-300-1.5
100-200-300-2S
100-200-300-1.5
100-200-300-2S
Hi,
pls try
pls try
string pattern = @"([A-Za-z]*\d+(\.\d+)?[A-Za-z]*(-[A-Za-z]*\d+(\.\d+)?[A-Za-z]*)*)";
This is a much shortened version of the initial string. In your code I see no use of the numbered capturing groups, so a non-capturing group is more efficient.
PS: did not work what?
What result did you receive?
string pattern = @"(?:-[A-Za-z]*\d+\.?\d*[A-Za-z]*)+";
PS: did not work what?
What result did you receive?
Or even shorter, although possibly including characters from other languages:
string pattern = @"(?:-\p{L}*\d+\.?\d*\p{L}*)+";
I don't think the regex expression is the issue. Can you please post the constructor for the KeywordSearchCriteria object?
Could it have something to do with :
string replacement = Regex.Replace(searchText, pattern, "$0*");
/// <summary>
/// Summary description for Search Page
/// </summary>
public class Search
{
private KeywordSearchCriteria keywordSearchCriteria;
string replacement = Regex.Replace(searchText, pattern, "$0*");
/// <summary>
/// Summary description for Search Page
/// </summary>
public class Search
{
private KeywordSearchCriteria keywordSearchCriteria;
You should really be posting examples of inputs and their corresponding, expected outputs. Otherwise, we're all just playing a game of "guess and check," which isn't a very fun game.
Ok figured out the issues since i hard coded it and it worked. The way it's passed to the replacement string is where it's incorrect?
try
{
//Try strong Regex
string replacement = Regex.Replace(searchText, pattern, "$0*");
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = "100-201-103-0.2" };
try
{
//Try strong Regex
string replacement = Regex.Replace(searchText, pattern, "$0*");
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = "100-201-103-0.2" };
ok thats not right...how do i fix it?
How do I display the variable for the .cs file for web? ive been updating the .cs file and saving it and it refreshes the website
How do I display the variable for the .cs file for web? ive been updating the .cs file and saving it and it refreshes the website
If you really want the full string as a search pattern, you can use the following code. But I don't think that's the intended usage:
string pattern = @"(?:\p{L}*\d+\.?\d*\p{L}*-?)+";
try
{
//Try strong Regex
string replacement = Regex.Replace(searchText, pattern, "$0");
keywordSearchCriteria = new KeywordSearchCriteria { QueryText = replacement };
I mean it will work for this specific case.
But it was designed for partial searches (that's what the * in "$0*" was for), so you should check if it still works the same for the strings without periods in them.
But it was designed for partial searches (that's what the * in "$0*" was for), so you should check if it still works the same for the strings without periods in them.
Hi Dan,
Thank you for the response and yes, you are correct. We have items in our database that have different patterns in the likes of combining both alpha-numeric values. A typical Item Number would look like this:
100-ABC-200-300
123-456-789
K8012
A123
ABC1234
ABC-21
ABC-100
A123-12
AB-123
AB-012-1023
ABCD-12
ABCD-123
ABCD-1234
A123-123
AbcDefg-1234
123-456-789-1
The regexp pattern code seems to capture all of these except anything that ends in a letter OR if there's a decimal. Two examples where this is not showing up in the search:
123-456-789-0.1
123-456-789A
Code again:
Thank you for the response and yes, you are correct. We have items in our database that have different patterns in the likes of combining both alpha-numeric values. A typical Item Number would look like this:
100-ABC-200-300
123-456-789
K8012
A123
ABC1234
ABC-21
ABC-100
A123-12
AB-123
AB-012-1023
ABCD-12
ABCD-123
ABCD-1234
A123-123
AbcDefg-1234
123-456-789-1
The regexp pattern code seems to capture all of these except anything that ends in a letter OR if there's a decimal. Two examples where this is not showing up in the search:
123-456-789-0.1
123-456-789A
Code again:
string pattern = @"(-[A-Za-z]*\d+[A-Za-z]*(-[A-Za-z]*\d+[A-Za-z]*)*)";
ok i manage to get output from the code.
(-[A-Za-z]*\d+[A-Za-z]*(-[
So with this expression, the output is:
123-456-789-1*.1
The value we need to search for is 123-456-789-1.1
(-[A-Za-z]*\d+[A-Za-z]*(-[
So with this expression, the output is:
123-456-789-1*.1
The value we need to search for is 123-456-789-1.1
Most of the solutions proposed will give you 123-456-789-1.1. Which will be transformed into "123-456-789-1.1*", which apparently does not work with your search engine.
We already gave you correct expressions so the strings with dots in them are accepted.
Why the search does not work when you add a "*"? Not enough info to answer that question.
Either contact the original programmer, post all the code here or get a new programmer to fix the bug.
We already gave you correct expressions so the strings with dots in them are accepted.
Why the search does not work when you add a "*"? Not enough info to answer that question.
Either contact the original programmer, post all the code here or get a new programmer to fix the bug.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial