Implement regular expression to a text file

sampath meka

Hello All,
I have one query regarding regular expression implementation to a file.I have a large text file in which i am providing a set of lines has example:
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/SOURCE/yib_swa_signals.h 1.10.1.4 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_swa_signals.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/SOURCE/yib_swa_signals_sub.h 1.11.1.4 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_swa_signals_sub.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/SOURCE/yib_swa_signals_trim.h 1.4.1.5 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_swa_signals_trim.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_fault_manager\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_fwd_rev_detection\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/SOURCE/yib_swa_signals_priv.h 1.9 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_swa_signals_priv.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_initialization\yib_polyspace_drs.h

if i give filename has yib_polyspace_drs.h then i should get below lines has output from regular expression
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_fault_manager\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_fwd_rev_detection\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_initialization\yib_polyspace_drs.h
/SCS/SCS_Core_Based/08_Software/Application/YIB/YIB_GEN2/MAIN/APPLICATION/DOCS/Private/TestSpecifications/yib_polyspace_drs.h 1.3 d:\Sandbox\BMW35UP_I390_1.443_Testview\MainMicro\Application\Yib\Yib_Main\_yib_lat_accel_signals\yib_polyspace_drs.h
Kindly help me to implement regular expression .
Thanks & Regards,
Sampath

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted answer
To search the exact word you need to add word boundary meta-characters, \b, at both ends of the word to be matched:

reg.Pattern = "^.*?\byib_polyspace_drs\.h\b.*$"

Note though that if a line contains two or more instances of yib_polyspace_drs.h 1.3 then the line will be matched if at least one of them is a complete word.
sampath meka12y ago
One more doubt what should be added to strictly match the exact word. if word is abb_yib_polyspace_drs.h is also coming in the matches. How to search exact string. Thank you
sampath meka12y ago
Thanks working fine sorry to trouble you
Vulpes12y ago
Yes, there is a difference in the way the 'multiline' option is implemented .

In VBS you have to set a property of the RegExp object rather than insert (?m) in the regular expression itself.

The following script seems to be working OK:

Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("sampath_meka.txt", 1)
text = objFile.ReadAll
objFile.Close

Set reg = New RegExp
reg.Multiline = True
reg.Global = True
reg.Pattern = "^.*?yib_polyspace_drs\.h.*$"
Set mc = reg.Execute(text)
For Each m in mc
Wscript.echo m.Value
Next
Vulpes12y ago
I'll need to check how VBS does regular expressions as there tends to be small differences between dialects.

I'll get back to you later today.
sampath meka12y ago
Hello vulpes Sorry to trouble you again its working fine in VB .net actually i need the code in VBS.I thought if code works in VB it will work in VBS but its not working in VBS. Sorry please dont mind
Vulpes12y ago
OK, here's the equivalent code in VB.NET.

It seems to be working fine:

Imports System
Imports System.IO
Imports System.Text.RegularExpressions

Module Program

Sub Main()

Dim text As String = File.ReadAllText("sampath_meka.txt")
Dim reg As String = "(?m)^.*?yib_polyspace_drs\.h.*$"
Dim mc As MatchCollection = Regex.Matches(text, reg)
For Each m As Match In mc
Console.WriteLine(m.Value)
Next
Console.ReadKey

End Sub

End Module
sampath meka12y ago
Yes.Actually the reply given by you is working fine for C# code but its displaying error when running same code in vb .net.I will be very much thankful if you provide the answer in vb.net
Vulpes12y ago
Well, AFAICS, the code I gave in this thread:

http://www.c-sharpcorner.com/Forums/Thread/273948/how-to-implement-regular-expression-to-a-text-file.aspx

also works for the above file if it is indeed different from the previous one.

Note that if you want the text beginning d:\SandBox to begin on a different line, then the file will need to contain new line characters before that part of the text. At the moment it doesn't - it's all one line - when I paste it into notepad.

However, I see that you've now posted this question in the VB.NET category rather than in the C# category. So are you asking for the same code translated to VB.NET?