473,378 Members | 1,507 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Q: Regular expression

Hi

Can anybody give me some advice on a regular expression?

I want to get two substrings out of a string like:

"This is a test & I hope it works"

i.e. I want the substring before the & and the substring after the &:

"This is a " and " I hope it works"

Can anybody tell me what the regular expression, using Regex, is?

Thanks in advance

Geoff
Nov 21 '05 #1
6 1050
>Can anybody tell me what the regular expression, using Regex, is?

Any reason you have to use Regex for this? It would be trivial to do
with just the String class (or VB's InStr, Left, Mid functions).

Mattias

--
Mattias Sjögren [MVP] mattias @ mvps.org
http://www.msjogren.net/dotnet/ | http://www.dotnetinterop.com
Please reply only to the newsgroup.
Nov 21 '05 #2
"Geoff Jones" <no********@email.com> schrieb

Can anybody give me some advice on a regular expression?

Have a look @ this group for language unrelated questions:
microsoft.public.dotnet.framework
Armin
Nov 21 '05 #3
"Geoff Jones" <no********@email.com> schrieb:
Can anybody give me some advice on a regular expression?

I want to get two substrings out of a string like:

"This is a test & I hope it works"

i.e. I want the substring before the & and the substring after the &:

"This is a " and " I hope it works"

Can anybody tell me what the regular expression, using Regex, is?


What's the reason why you don't use 'Split'?

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>
Nov 21 '05 #4
Hi Jeoff,

If you really want to use regex for this job it will be:

~
Dim str As String = "This is a test & I hope it works"
Dim result() As String = Regex.Split(str, "&")
~

However, if I were you I would use:

~
Dim str As String = "This is a test & I hope it works"
Dim result() As String = str.Split("&"c)
~

Hope it helps

Roman
Nov 21 '05 #5
Thanks everyone.

The reason I wanted to use Regular expressions was merely to learn more
about it i.e. I agree that the String class can be used but I wondered how
Regex could be used.

Thanks again

Geoff

"Dragon" <no@spam.please> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Hi Jeoff,

If you really want to use regex for this job it will be:

~
Dim str As String = "This is a test & I hope it works"
Dim result() As String = Regex.Split(str, "&")
~

However, if I were you I would use:

~
Dim str As String = "This is a test & I hope it works"
Dim result() As String = str.Split("&"c)
~

Hope it helps

Roman

Nov 21 '05 #6
For that specific case, use:

(\w+\s)+(?=&)|(\w+\s)+

Explanation:

(\w+\s)+ => any word followed by a space, one or more times
(?=&) => conditional, specifying the next character must be a '&'
| => optional
so:
(\w+\s)+(?=&) => any word followed by a space, one or more times,
matched with a '&' character
Use the 'The regulator' to test your expressions: http://regex.osherove.com/

[]s
Cesar



"Geoff Jones" <no********@email.com> escreveu na mensagem
news:42***********************@news.dial.pipex.com ...
Hi

Can anybody give me some advice on a regular expression?

I want to get two substrings out of a string like:

"This is a test & I hope it works"

i.e. I want the substring before the & and the substring after the &:

"This is a " and " I hope it works"

Can anybody tell me what the regular expression, using Regex, is?

Thanks in advance

Geoff

Nov 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Kenneth McDonald | last post by:
I'm working on the 0.8 release of my 'rex' module, and would appreciate feedback, suggestions, and criticism as I work towards finalizing the API and feature sets. rex is a module intended to make...
4
by: Buddy | last post by:
Can someone please show me how to create a regular expression to do the following My text is set to MyColumn{1, 100} Test I want a regular expression that sets the text to the following...
4
by: Neri | last post by:
Some document processing program I write has to deal with documents that have headers and footers that are unnecessary for the main processing part. Therefore, I'm using a regular expression to go...
11
by: Dimitris Georgakopuolos | last post by:
Hello, I have a text file that I load up to a string. The text includes certain expression like {firstName} or {userName} that I want to match and then replace with a new expression. However,...
3
by: James D. Marshall | last post by:
The issue at hand, I believe is my comprehension of using regular expression, specially to assist in replacing the expression with other text. using regular expression (\s*) my understanding is...
7
by: Billa | last post by:
Hi, I am replaceing a big string using different regular expressions (see some example at the end of the message). The problem is whenever I apply a "replace" it makes a new copy of string and I...
9
by: Pete Davis | last post by:
I'm using regular expressions to extract some data and some links from some web pages. I download the page and then I want to get a list of certain links. For building regular expressions, I use...
25
by: Mike | last post by:
I have a regular expression (^(.+)(?=\s*).*\1 ) that results in matches. I would like to get what the actual regular expression is. In other words, when I apply ^(.+)(?=\s*).*\1 to " HEART...
1
by: Allan Ebdrup | last post by:
I have a dynamic list of regular expressions, the expressions don't change very often but they can change. And I have a single string that I want to match the regular expressions against and find...
1
by: NvrBst | last post by:
I want to use the .replace() method with the regular expression /^ %VAR % =,($|&)/. The following DOESN'T replace the "^default.aspx=,($|&)" regular expression with "":...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.