how to make a regular expression in a string after a certain line

Question

0.00/5 (No votes)

See more:

Hi coder i am new in regular expression so i don't know much about i will show you what i have and what i did.

String on which i have to put regular expression i have two search ticket number in it like 220-7242648582 for this i use [0-9||-]{14} regex
now the think is that it is a repeated string and i want to find ticket number after last )>md and before )md

HTML

    RP/DCA1S219C/DCA1S219C            SL/SU   5APR13/2119Z   23ZEBK
   42 FA PAX 220-7242648582-83/ETLH/USD1166.75/04APR13/DCA1S211E/4
   9881134/S3-7/P1
    43 FA PAX 220-7242648584-85/ETLH/USD1166.75/04APR13/DCA1S211E/4
   9881134/S3-7/P2
022 AF/FA 220-7242636221-22/ETLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
022 AF/FA 220-7242636223-24/ETLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
022 RF-WS-NMC-US/WSTNGTNG CR-NYC1S21DD 33895934 SU 9999WS/RO
    -9C9482E6 NYCW33TNG 00000000 04APR0223Z
022/033 XF/FA 220-7242636221-22/ETLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
033 AF/FA 220-7242636221-22/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/

)>md
RP/DCA1S219C/DCA1S219C            SL/SU   5APR13/2119Z   23ZEBK
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
    033 RF-2G-NYC1S21SP/00102G CR-NYC1S21DD 33895934 GS 00102G/R
    O-67ED3FEE NYC1S21SP 33608293 04APR0514Z
 022/034 XF/FA 220-7242636223-24/ETLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
034 AF/FA 220-7242636223-24/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
034 RF-2G-NYC1S21SP/00102G CR-NYC1S21DD 33895934 GS 00102G/R
    O-67ED3FEE NYC1S21SP 33608293 04APR0514Z
033/035 XF/FA 220-7242636221-22/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
 034/035 XF/FA 220-7242636223-24/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)

 )>md
RP/DCA1S219C/DCA1S219C            SL/SU   5APR13/2119Z   23ZEBK
    O-67ED3FEE NYC1S21SP 33608293 04APR0514Z
033/035 XF/FA 220-7242636221-22/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
034/035 XF/FA 220-7242636223-24/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
035 RF-P-NYC1S21SP/00102G CR-NYC1S21DD 33895934 GS 00102G/RO
    -67ED3FEE NYC1S21SP 33608293 04APR0514Z
044 AF/FA 220-7242648582-83/ETLH/USD1166.75/04APR13/
    DCA1S211E/49881134/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
044 AF/FA 220-7242648584-85/ETLH/USD1166.75/04APR13/
    DCA1S211E/49881134/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
044 RF-MZ CR-DCA1S211E 49881134 SU 1983MZ/RO-67ECDAB1 DCA1S2
    10W 49592222 04APR0658Z
)md

thanks in advance

Posted 1-May-13 1:05am

amitesh1989

Updated 1-May-13 2:05am

Kenneth Haugland

v3

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kenneth Haugland · Answer 1 · 2013-05-01T02:06:00

Solution 1

There are lots of tools developed for RegEx, here is one of them:
Expresso - A Tool for Building and Testing Regular Expressions[^]

It really should be a great help to generate complex regex patterns.

Posted 1-May-13 2:06am

Kenneth Haugland

Comments

amitesh1989 1-May-13 8:26am

i know but i just need a regex for it because my query is different then what that tool gave it to me

Shahan Ayyub · Answer 2 · 2013-05-01T20:03:00

I would suggest you to take a substring from your LAST ' )>md' to ')md' like this:

 )>md
RP/DCA1S219C/DCA1S219C            SL/SU   5APR13/2119Z   23ZEBK
    O-67ED3FEE NYC1S21SP 33608293 04APR0514Z
033/035 XF/FA 220-7242636221-22/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
034/035 XF/FA 220-7242636223-24/EVLH/USD1166.75/03APR13/
    NYC1S21DD/33895934/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
035 RF-P-NYC1S21SP/00102G CR-NYC1S21DD 33895934 GS 00102G/RO
    -67ED3FEE NYC1S21SP 33608293 04APR0514Z
044 AF/FA 220-7242648582-83/ETLH/USD1166.75/04APR13/
    DCA1S211E/49881134/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/SABAHETA(ADT)
044 AF/FA 220-7242648584-85/ETLH/USD1166.75/04APR13/
    DCA1S211E/49881134/OU 341 S 13MAY SJJZAG/LH6001 T 13MAY
    ZAGFRA/LH 402 T 13MAY FRAEWR/LH7608 T 17JUL EWRMUC/
    LH1730 T 18JUL MUCSJJ/TRESNJO/FEJZO(ADT)
044 RF-MZ CR-DCA1S211E 49881134 SU 1983MZ/RO-67ECDAB1 DCA1S2
    10W 49592222 04APR0658Z
)md

and apply this regex pattern on it:

(\d{3}\-\d{10}\-\d{2})

It will give you all ticket number having format XXX-XXXXXXXXXX-XX. You can iterate over all the matches.

On the other hand your regex will be much more complex. This seems fast and easy to understand.

Also, I am expecting the regex you are using as mentioned in question [0-9||-]{14} will matches the string like:

2-2-2-2-2-2222

which is not a ticket number.

Hope it helps!