Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Course Of The Month
4 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
RegEx -- Delete Spaces at Beginning of Line, and Empty Lines
Posted on 2006-10-20
I have some original text that I am filtering using RegEx. Most stuff works like normal, but I'm having a hard time simulating a Trim() and also deleting empty lines. I want to use RegEx for this approach (i.e., not split and trim). In the following the "\r\n" is the standard ControlChars.CrLf characters.
originalText = "\r\nSecond line.\r\n Third line, with leading space.\r\n\r\nFifth line.\r\n"
I can remove the double CrLf in the middle:
cleanedText = Regex.Replace(originalText
But, how about the first one?
How about deleting the extra space in front of "Third line".
Looking for generic approach, not just for this example.
originalText = "\r\nSecond line.\r\n Third line, with leading space.\r\n\r\nFifth line.\r\n"
I can remove the double CrLf in the middle:
cleanedText = Regex.Replace(originalText
But, how about the first one?
How about deleting the extra space in front of "Third line".
Looking for generic approach, not just for this example.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
6 Comments
Active today
Hi GivenRandy;
This should do what you want.
Dim originalText As String = vbCrLf & "Second line." & vbCrLf & _
" Third line, with leading space." & vbCrLf & _
vbCrLf & "Fifth line." & vbCrLf
Dim cleanedText As String = Regex.Replace(originalText
"^(?<1>\r\n)*(?<2>\s*)(?<3
"$3" & vbCrLf, RegexOptions.Multiline)
MessageBox.Show(cleanedTex
Fernando
This should do what you want.
Dim originalText As String = vbCrLf & "Second line." & vbCrLf & _
" Third line, with leading space." & vbCrLf & _
vbCrLf & "Fifth line." & vbCrLf
Dim cleanedText As String = Regex.Replace(originalText
"^(?<1>\r\n)*(?<2>\s*)(?<3
"$3" & vbCrLf, RegexOptions.Multiline)
MessageBox.Show(cleanedTex
Fernando
Active today
Hi gangwisch;
GivenRandy also wants to remove all blank line from with in the string as well as leading spaces on lines with in the string. So then he would have to split the string loop through the array remove blank lines and make sure there is only one set of CrLf at the end of the line. The Regex will do it in one step.
Fernando
GivenRandy also wants to remove all blank line from with in the string as well as leading spaces on lines with in the string. So then he would have to split the string loop through the array remove blank lines and make sure there is only one set of CrLf at the end of the line. The Regex will do it in one step.
Fernando
Seems to work. Did you find a particular tool and/or book to be helpful? I know the basics of Regex, but need to improve.
Active today
Hi GivenRandy;
Sorry but I have not found any good book on regular expressions. When I started working with Regex in .Net I used a program called the Regulator. This program is available for download at http://sourceforge.net/projects/regulator/ . Since then I have written my own and have been using it, a project that I am still working on.
Good luck;
Fernando
Sorry but I have not found any good book on regular expressions. When I started working with Regex in .Net I used a program called the Regulator. This program is available for download at http://sourceforge.net/projects/regulator/ . Since then I have written my own and have been using it, a project that I am still working on.
Good luck;
Fernando
I put a similar question that you might want to look at:
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_22034295.html
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_22034295.html
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses
Course of the Month4 days, 11 hours left to enroll
690 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.