Regex - Regular Expression To Parse Whitespace-delimited Data?

Jun 18, 2009

I have written code to pull some data into a data table and do some data re-formatting. I need some help splitting some text into appropriate columns.

CASE 1

I have data formated like this that I need to split into 2 columns.

[Code]...

column is the first 11 characters That is easy.column 2 should contain all the text after the first 11 characters up to but not including the first number.The last column is all the text after column 2

View 4 Replies


ADVERTISEMENT

Building Regex (regular Expression) - Get Data Out Of String?

May 21, 2009

ok, For the moment I have a string() where each element is in the structure of

[Code]...

View 2 Replies

Regex - Capture The Repeating Data Using A Regular Expression In .Net?

Feb 7, 2011

I'm trying to find the right RegEx to capture some (potentially) repeating data. I don't know how many times it will repeat. If I give an exanple of the data and what I want to capture can anyone point me in the right direction? It's the .Net regex engine (Visual Basic)

[Code]...

View 1 Replies

Regular Expression To Parse Xml In .net?

Mar 24, 2010

I have the following function that I am using to remove the characters �4 and nulls from my xmlString but I can't find what do I need to change to avoid removing the from my ending tags. This is what I get when I run this function

<ARR>20080625<ARR><DEP>20110606<DEP><PCIID>626783<PCIID><NOPAX>1<NOPAX><TG><TG><HASPREV>FALSE<HASPREV><HASSUCC>FALSE<HASSUCC>

find out what do I need to change in my expression to keep the ending tag as </tag>

[Code]...

View 1 Replies

Create A Regular Expression To Parse My SQL Statement?

Feb 26, 2009

I want to extract

[code]...

using a regular expression. I have a regex like this:

FROM.*order

which extracts FROM codes WHERE FieldName='ContactMethod' and IsNull(Deactived,'') != 'T' order Also, how can I get rid of the capitalization?

View 4 Replies

Regex :: How To Write Regular Expression

Sep 14, 2010

My coworker needs me to write him a regular expression for his vb.net app.I do not know vb and he does not know regex.The regex he needs is:/.*web id: ?(d+).*/iBasically he needs to search a string for something like "web id: 345" or "web id:2534" and retrieve the ID.He took what I gave him above and was able to put this together:

Dim strPattern As String = ".*web id: ?(d+).*"
Dim strReplacement$ = "$1"
GetWebId$ = Regex.Replace(LCase$(strNote$), strPattern$, strReplacement$)

[code].....

View 2 Replies

Regex - ASP Regular Expression For UK Telephone Format?

Sep 23, 2009

I want regular expression validator for my telephone field in VB.net. Telephone format should be (+)xx-(0)xxxx-xxxxxx ext xxxx (Optional) example my number would appear as 44-7966-591739 Screen would be formatted to show +44-(0)7966-591739 ext?

View 3 Replies

Regex - Regular Expression With Specific Criteria

Jan 31, 2011

I'm trying to type a regular expression that follows the following format: [URL] There are no special characters or numbers permitted for this criteria. I thought I had it down, but I'm a bit rusty with regular expressions and when I tested mine, it failed all across the boards. So far, my regular is expression is:

[Code]...

View 3 Replies

Regex - Parsing Excel Reference With Regular Expression?

Oct 14, 2010

Excel returns a reference of the form

=Sheet1!R14C1R22C71junk

("junk" won't normally be there, but I want to be sure that there's no extraneous text.)I would like to 'split' this into a VB array, where

a(0)="Sheet1"
a(1)="14"
a(2)="1"

[code]....

I'm sure it can be done easily with a regular expression, but I just can't get the hang of it.

View 2 Replies

Regex - Regular Expression That Requires At Least ONE Digits And SIX Maximum

Jan 21, 2011

I need a regular expression that requires at least ONE digits and SIX maximum. I've worked out this, but neither of them seems to work. ^[0-9][0-9]?[0-9]?[0-9]?[0-9]?[0-9]?$ ^[0-999999]$

View 4 Replies

VS 2010 Proper Regular Expression (Regex) Pattern?

Apr 24, 2012

It seems up until now I've never used Regex, nor even heard of it. But once I did I realized how extremely useful this is. Having said, it's been 2 days since I've began looking into constructing my own patterns. My most recent being for decimals. Is the pattern I provided below "proper"? and are there also any improvements I could be making for a more efficient patter, which would minimize any possibility of a loophole? [code] So for my use, this is doing what it's supposed to being doing under every test I can through at it. But do mind the 0. and .0, I have a function to normalize these as they are proper, I just pad the left and right accordingly. I found most regex questions asked here..and yes I am doing this in vb.net so it fits. If not, then feel free to move this post somewhere else better suited for the topic of discussion.

View 12 Replies

Regex - Extract SubString Based On Regular Expression Match

Apr 26, 2012

Quick RegExp problem (i hope). I need to identify a sub string from any string based on a regular expression. For Example, take the following strings:

[Code]...

View 3 Replies

Regex - Regular Expression To Check Input On Multiline Textbox?

Mar 15, 2011

regex - regular expression to check input on multiline textbox

View 5 Replies

Regex - Regular Expression To Convert Ul To Textformat And Back, With A Different Attribute Value For First Tag ?

Apr 1, 2010

This is a related to a previous question I have asked here, see the link below for a brief description as to why I am trying to do this.Regular expression from font to span (size and colour) and back (VB.NET).Basically I need a regex replace function (or if this can be done in pure VB then that's fine) to convert all ul tags in a string to textindent tags, with a different attribute value for the first textindent tag.For example:

<ul>
<li>This is some text</li>
<li>This is some more text</li>[code].....

Basically I want the first ul tag to have no indenting, but all nested ul tags to have an indent of 20.

View 2 Replies

Regex Regular Expression To Remove Lines Which Start With Certain Text?

Mar 24, 2012

I know it may be quite easily for you. i have a text which contains 40 lines, I want to remove lines which starts with a constant text. check below data.

When I used (?mn)[+CMGL:].*($) it removes the whole text , when I use (?mn)[+CMGL:].*(
) , it only leaves the first line.
+CMGL: 0,1,,159
07910201956905F0440B910201532762F20008709021225282808
+CMGL: 1,1,,159

[Code]...

View 1 Replies

Regular Expression (RegEx) To Replace Floating-point Numbers In XML?

Aug 22, 2011

I'm using Visual Basic 2010 Express to edit an XML file. I want to replace items that have (typically) non-zero floating point numbers with a single zero.

View 4 Replies

Regex - .net Regular Expression To Match Two Words Separated By Comma Not Working?

Mar 4, 2010

I am pretty good with perl regular expressions but evidently I am at a loss on why this doesn't work.The code below stores "Person Test" in output variable.

im output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)", RegexOptions.Singleline)
output = re.Replace(userName, "$2 $1")

So why doesn't the following code store "#Test##Person#" in output variable.

Dim output As String
Dim userName As String = "Test, Person"
Dim re As New Regex("(w+),s(w+)")
For Each Match As Match In re.Matches(userName)
output &= "#" & Match.ToString & "#"
Next

View 2 Replies

Regex - Regular Expression Needed To Replace Return Character With Another String?

Jul 20, 2009

I'm trying to replace all the carriage return characters in a string obtained from a multi line text box in a Windows Form with the string ", <BR>" so that when I use the string in some HTML it displays correctly.

Function Blah(ByVal strInput As String) As String
Dim rexCR As Object
rexCR = CreateObject("VBScript.RegExp")

[code]....

View 5 Replies

Regex - Regular Expression To Extract Numbers From Long String Containing Lots Of Punctuation?

Aug 27, 2009

I am trying to separate numbers from a string which includes %,/,etc for eg (%2459348?:, or :2434545/%). How can I separate it, in VB.net

View 4 Replies

Get A Regular Expression That Can Validate That A String Is An Alphanumeric Comma Delimited String?

Jun 23, 2011

I need a regular expression that can validate that a string is an alphanumeric comma delimited string.

Examples:

123, 4A67, GGG, 767 would be valid.
12333, 78787&*, GH778 would be invalid
fghkjhfdg8797< would be invalid

This is what I have so far, but isn't quite right: ^(?=.*[a-zA-Z0-9][,]).*$

View 3 Replies

Regex - Regular Expression To Split By Comma + Ignores Comma Within Double Quotes?

Feb 7, 2012

I'm trying to parse csv file with VB.NET.csv files contains value like 0,"1,2,3",4 which splits in 5 instead of 3. There are many examples with other languages in Stockoverflow but I can't implement it in VB.NET.Here is my code so far but it doesn't work...

Dim t As String() = Regex.Split(str(i), ",(?=([^""]*""[^""]*"")*[^""]*$)")

View 2 Replies

Regular Expression + Txt File = Captured Data?

Nov 16, 2011

I'm having trouble trying to find the best method to do what I'm needing.

I'm thinking of using a regular expression to read a .txt file and parse out the MAC id information that will be in the text file. I was wondering if there was an easier way to do it or what the best way to do this is.

readall(textfile)
macID = d{1, 4}.d{1, 4}.d{1, 4}
totalMacInfo = all the macs in the text file?

If you guys have an alternative solution or a good way to write out the code I am open to suggestions. Not exactly sure how best to mix the expression into reading a txt file to get the data i need.

View 33 Replies

Regular Expression - Grab Data Between Two Sets Of IDs

Jun 3, 2011

I have a regular expression that I use to grab data between two sets of id's for example:
<CLASSCOD>70</CLASSCOD>
The regular expression I use is:
(?<=<CLASSCOD>)(?:[^<]|<(?!/CLASSCOD))*
Which works in most case but when I have a single value like this
<CLASSCOD>N</CLASSCOD>
It says there are no matches.

The whole data string looks like this :
<STATUS>PRESOL</STATUS>
<DATE>0601</DATE>
<YEAR>11</YEAR>
<AGENCY>Department of the Interior</AGENCY>
<OFFICE>Bureau of Indian Affairs</OFFICE>
[Code] .....

View 2 Replies

C# - Parse An Expression And Retrieve A Parse Tree?

Jun 8, 2012

I just want to parse simple expressions like IIF(FVAL(PFC) = TRUE, (IIF((ORGVAL(BAS, "2012/12/31") + ORGVAL(DA)) < 6500, (FVAL(BAS) + FVAL(DA)) * 12%, 780)), 0)`After parsing this I should be able to know what functions contains what parameters.

[Code]...

I'm stuck with .Net Framework 2.0, so no Linq or lambda expression goodies for me. Also I want to include the code in my custom library and not just reference it. Can anyone point me to some good library or code.

I just need to parse and not evaluate the expression and find what tokens are in use. After finding the tokens I need to change the expression string before parsing, like if the function ORGVAL is used then the parameter passed has has to be prefixed by an underscore. Like ORGVAL(BAS) will transform to ORGVAL(_BAS). Some functions can have tow parameters like ORGVAL(BAS, "2012/12/31") and this will transform to ORGVAL(_BAS, "2012/12/31")

NOTE: IF THERE ARE OTHER WAYS OF DOING IT PLEASE LET ME KNOW. I WOULD LOVE TO AVOID A PARSER AND LEXER.

View 3 Replies

Parse Delimited CSV In .NET

Apr 10, 2009

I have a text file that is in a comma separated format, delimited by " on most fields. I am trying to get that into something I can enumerate through (Generic Collection, for example). I don't have control over how the file is output nor the character it uses for the delimiter.

[Code]...

View 12 Replies

Way To Parse A Tab Delimited File?

Mar 5, 2010

I was wondering if anyone had a better(faster) way to parse a Tab delimited file in VB.net. need to read a file into an SQL table and the file contains about 300,000+ rows

Using MyReader As New Microsoft.VisualBasic.FileIO.TextFieldParser(FilePath)
MyReader.TextFieldType = FileIO.FieldType.Delimited
MyReader.SetDelimiters(vbTab)

[code].....

View 2 Replies

Fastest Way To Parse A Tab Delimited File

Mar 29, 2010

I was wondering if anyone had a better(faster) way to parse a Tab delimited file in VB.net. I need to read a file into an SQL table and the file contains about 300,000+ rows. Takes quiet a while. at the moment i have the below [Code].

View 6 Replies

Parse A Space Delimited String Into A Double Array?

May 25, 2010

in parsing a string which is delimited by space in to a Double Array

View 1 Replies

Regular Expressions - Behind The Scenes - Parse A String?

May 5, 2009

What happens exactly when you use a regular expression? How do they parse a string so quickly?

View 2 Replies

Regex - C# Using Regular Expressions?

Nov 11, 2011

The following works in vb.net, and basically only allows characters on a standard US Keyboard. Any other character pasted gets deleted. I use the following regular expression code:

"[^A-Za-z0-9[{}]`~!@#$%^&*()_-+=\/:;'""<>,.|? ]", "")

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved