473,322 Members | 1,268 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,322 software developers and data experts.

Regex Question

I have a text table with the following columns

Minutes
Item#
Day
Date
Time
Number
CallTo
RateCode
RatePd
Feature
AirCharge
AddCharge
Total Charge

Here is my problem, not every record will have information for every column.
since this is a text table it is pushed together likes so

min item# day date time number callto ratecode ratepd feature airchg addchg
ttlchg
1 10 FRI 09/05 7:56PM Incomi Cl 5KNW DT M2MC 0.00 0.00 0.00
1 9 09/05 7:58PM Incomi CL 5KNW DT 0.00

so as you can see the first row has all the information and is easy to match
using the following pattern

"(?<Minutes>(\d+))\s*(?<Item>(\d+))\s*(?<Day>(MON| TUE|WED|THU|FRI|SAT))\s*(?<Date>(\d+/\d+))\s*(?<Time>(\d+:\d+\w+))\s*(?<Number>(\d+-\d+-\d+))\s*(?<Callto>(\w+\s\w+))\s*(?<RateCode>(5KNW| 7ESM|FN4N|7RM6))\S*(?<RatePd>(DT|NW))\s*(?<Feautre >(M2MC|VM|CW))\s*(?<AirCharge>(\d+\.\d+))\s*(?<Add Charge>(\d+\.\d+))\s*(?<TotalCharge>(\d+\.\d+))"

but the second row does not have all of the information there so it is hard
to get the information that i need

So i was wondering if anyone knew of a way that i could make a pattern that
is similiar to the pattern that i have above but will skip over a group if
that info is not that and basically return a null value or something so that
i can get the data that i need from every row in this table. I have to add
this data to a database and this is the only format that i can get cingular
to give me this info in.

Thanks Again.

WStoreyII
Nov 21 '05 #1
1 1277
WStoreyII,
I would make each group that is optional, optional using the ? qualifier
(zero or one matches).

So for just the Day group I would use:

(?<Day>(MON|TUE|WED|THU|FRI|SAT)?)

Which says that the Day named group needs to be zero or one of MON, TUE,
WED, THU, FRI, or SAT.

For the other groups that may or may not be there, I would do the same
thing.

My concern is the final 0.00 in your second sample: AirCharge, AddCharge, or
Total Charge?

Hope this helps
Jay
"WStoreyII" <WS*******@discussions.microsoft.com> wrote in message
news:6E**********************************@microsof t.com...
I have a text table with the following columns

Minutes
Item#
Day
Date
Time
Number
CallTo
RateCode
RatePd
Feature
AirCharge
AddCharge
Total Charge

Here is my problem, not every record will have information for every
column.
since this is a text table it is pushed together likes so

min item# day date time number callto ratecode ratepd feature airchg
addchg
ttlchg
1 10 FRI 09/05 7:56PM Incomi Cl 5KNW DT M2MC 0.00 0.00 0.00
1 9 09/05 7:58PM Incomi CL 5KNW DT 0.00

so as you can see the first row has all the information and is easy to
match
using the following pattern

"(?<Minutes>(\d+))\s*(?<Item>(\d+))\s*(?<Day>(MON| TUE|WED|THU|FRI|SAT))\s*(?<Date>(\d+/\d+))\s*(?<Time>(\d+:\d+\w+))\s*(?<Number>(\d+-\d+-\d+))\s*(?<Callto>(\w+\s\w+))\s*(?<RateCode>(5KNW| 7ESM|FN4N|7RM6))\S*(?<RatePd>(DT|NW))\s*(?<Feautre >(M2MC|VM|CW))\s*(?<AirCharge>(\d+\.\d+))\s*(?<Add Charge>(\d+\.\d+))\s*(?<TotalCharge>(\d+\.\d+))"

but the second row does not have all of the information there so it is
hard
to get the information that i need

So i was wondering if anyone knew of a way that i could make a pattern
that
is similiar to the pattern that i have above but will skip over a group if
that info is not that and basically return a null value or something so
that
i can get the data that i need from every row in this table. I have to
add
this data to a database and this is the only format that i can get
cingular
to give me this info in.

Thanks Again.

WStoreyII

Nov 21 '05 #2

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

Similar topics

4
by: engwar1 | last post by:
Not sure where to ask this. Please suggest another newsgroup if this isn't the best place for this question. I'm new to both vb.net and regex. I need a regular expression that will validate what...
4
by: aevans1108 | last post by:
expanding this message to microsoft.public.dotnet.xml Greetings Please direct me to the right group if this is an inappropriate place to post this question. Thanks. I want to format a...
2
by: Tim Conner | last post by:
Hi, Thanks to Peter, Chris and Steven who answered my previous answer about regex to split a string. Actually, it was as easy as create a regex with the pattern "/*-+()," and most of my string...
6
by: Du Dang | last post by:
Text: ===================== <script1> ***stuff A </script1> ***more stuff <script2> ***stuff B
17
by: clintonG | last post by:
I'm using an .aspx tool I found at but as nice as the interface is I think I need to consider using others. Some can generate C# I understand. Your preferences please... <%= Clinton Gallagher ...
5
by: Chris | last post by:
How Do I use the following auto-generated code from The Regulator? '------------------------------------------------------------------------------ ' <autogenerated> ' This code was generated...
6
by: Martin Evans | last post by:
Sorry, yet another REGEX question. I've been struggling with trying to get a regular expression to do the following example in Python: Search and replace all instances of "sleeping" with "dead"....
7
by: Extremest | last post by:
I am using this regex. static Regex paranthesis = new Regex("(\\d*/\\d*)", RegexOptions.IgnoreCase); it should find everything between parenthesis that have some numbers onyl then a forward...
6
by: Phil Barber | last post by:
I am using Regex to validate a file name. I have everything I need except I would like the dot(.) in the filename only to appear once. My question is it possible to allow one instance of character...
6
by: | last post by:
Hi all, Sorry for the lengthy post but as I learned I should post concise-and-complete code. So the code belows shows that the execution of ValidateAddress consumes a lot of time. In the test...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.