Search code examples
c#regexmatchline

Looking for a C# Regex pattern matching for a series of lines

I am presented with a data file and in the file I have a line I need to match, then I'll read the next few lines until I find this match again.

Here are the various structures of the lines I need to match:

69 1.0 PKS-EKC-FlYCTRK--Y 2,110.28 2,110.28
70 2.0 ACS-PMM 31.75 63.50
72 1.0 PKS-TR1-CRD 308.14 308.14
73 1.0 QTC-01HZZ-RBER058- 1,725.57 1,725.57
74 1.0 MGS-05B-4TC-120--8 1,222.84 1,222.84
75 1.0 ACS-VGY 98.60 98.60
76 2.0 ACS-VGG 27.27 54.53
77 2.0 ACS-VGQ 110.93 221.86
78 2.0 ECS-ENM--845 1,294.18 2,588.36
80 1.0 FREIGHT 4,188.00 4,188.00

Here is what I have thought of so far but it only matches one line, I need to match them all.

(\d{2})\s(\d{1}.\d{1})\s(\w+?-\w+?-\w+?--\w)\s(\d+?,\d+.\d+)\s(\d+?,\d+.\d+)
Solution

  • I love a good regex problem. Solved!

    ^(\d{2})\s(\d\.\d)\s(\S*)\s((\d*\,\d*.\d{2})|(\d*.\d{2}))\s((\d*\,\d*.\d{2})|(\d*.\d{2}))$

    There are always two digits at the start:

    ^(\d{2})

    Followed by a number with one decimal place:

    (\d\.\d)

    Followed by some string of non-space characters:

    (\S*)

    Using OR to deal with different numeric structures:

    ((\d*\,\d*.\d{2})|(\d*.\d{2}))

    regex101.com is your friend.