regex question

[Sa¹o Zagoranski]

Hi,

could someone help me putting together a regex expression for my problem?

I need my search filter to treat spaces and commas in the query the same
way no matter how many there are...

Something like this:
If a user enter "song, song" the filter has to find:
song song
song song
song,song
as well as
blasong, songbla

any tips?

thanks,
sa¹o

[Kevin Spencer]

You would have to explain the business rules of your "search filter."

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

Sequence, Selection, Iteration.
"Sa¹o Zagoranski" <sa**@skz.siwro te in message
news:Z7******** ************@ne ws.siol.net...

Hi,

could someone help me putting together a regex expression for my problem?

I need my search filter to treat spaces and commas in the query the same
way no matter how many there are...

Something like this:
If a user enter "song, song" the filter has to find:
song song
song song
song,song
as well as
blasong, songbla

any tips?

thanks,
sa¹o

[Sa¹o Zagoranski]

You would have to explain the business rules of your "search filter."

As I wrote:

Something like this:

If a user enter "song, song" the filter has to find:
song song
song song
song,song

as well as:

blasong, songbla
blasong, songbla

but not this:
song sometext song

The filter has to ignore spaces and commas between the words entered.

[Anoop]

If the search text is being entered in a Textbox or any other visual
component then one Solution could be to capture the Keypress event and then
ignore the space and comma and just store the actual text in a variable but
display everything.
I am new to the .net but there should a method to find a particular
character in a string and retrieve the rest of the string.
"Sa¹o Zagoranski" <sa**@skz.siwro te in message
news:HW******** ************@ne ws.siol.net...

>

You would have to explain the business rules of your "search filter."

As I wrote:

Something like this:

If a user enter "song, song" the filter has to find:
song song
song song
song,song

as well as:

blasong, songbla
blasong, songbla

but not this:
song sometext song

The filter has to ignore spaces and commas between the words entered.

[Jesse Houwing]

* Anoop wrote, On 27-7-2006 0:09:

If the search text is being entered in a Textbox or any other visual
component then one Solution could be to capture the Keypress event and then
ignore the space and comma and just store the actual text in a variable but
display everything.
I am new to the .net but there should a method to find a particular
character in a string and retrieve the rest of the string.
"Sa¹o Zagoranski" <sa**@skz.siwro te in message
news:HW******** ************@ne ws.siol.net...

>>You would have to explain the business rules of your "search filter."

As I wrote:

Something like this:

> If a user enter "song, song" the filter has to find:
song song
song song
song,song

as well as:

> blasong, songbla
blasong, songbla

but not this:
song sometext song

The filter has to ignore spaces and commas between the words entered.

You'll have to generate a regex on the fly to handle this:

string input = "bla bla song song...... bla bla";
// read the input from the user
string inputRegex = "song, song";
// replace space with comma, because Regex.Escape will escape whitespace
inputRegex = inputRegex.Repl ace(' ', ',');
// Escape the string to prevent regex injection
inputRegex = Regex.Escape(in putRegex);
// build the actual search expression
string searchExpressio n = Regex.Replace(i nputRegex, "[, ]+", "[, ]+",
RegexOptions.No ne);
// find all matches in the string
MatchCollection ms = Regex.Matches(i nputRegex, searchExpressio n);

This will do exactly what you need.

Jesse

[Sašo Zagoranski]

Thanks for your reply Jesse...

You probably meant:
MatchCollection ms = Regex.Matches(i nput, searchExpressio n);
correct? Otherwise the "input" isn't used anywhere...

In any case this doesn't return any matches...

>
You'll have to generate a regex on the fly to handle this:

string input = "bla bla song song...... bla bla";
// read the input from the user
string inputRegex = "song, song";
// replace space with comma, because Regex.Escape will escape whitespace
inputRegex = inputRegex.Repl ace(' ', ',');
// Escape the string to prevent regex injection
inputRegex = Regex.Escape(in putRegex);
// build the actual search expression
string searchExpressio n = Regex.Replace(i nputRegex, "[, ]+", "[, ]+",
RegexOptions.No ne);
// find all matches in the string
MatchCollection ms = Regex.Matches(i nputRegex, searchExpressio n);

This will do exactly what you need.

Jesse

[John B]

Sa¹o Zagoranski wrote:

>

>You would have to explain the business rules of your "search filter."

As I wrote:

Something like this:

If a user enter "song, song" the filter has to find:
song song
song song
song,song

as well as:

blasong, songbla
blasong, songbla

but not this:
song sometext song

The filter has to ignore spaces and commas between the words entered.

..*song(?:\ *,*\ *)song.*

Explanation from The Regulator (thanks to Roy O)

.. (any character)
* (zero or more times)
song
Non-capturing Group
' ' (space)
* (zero or more times)
,
* (zero or more times)
' ' (space)
* (zero or more times)
End Capture
song
.. (any character)
* (zero or more times)

However that will also match songsong.
Dont know if you want that or not, if not then you would have to do it
with an or so it matches one or more spaces or one or more commas (dont
know if you want song,,song to match either).

You get the idea.

JB

>