How to delete empty lines from a word file

Question

0.00/5 (No votes)

See more:

Hi,

I am fetching data from a MS Word file into a text box in VB.Net and am displaying it paragraph by paragraph. It is working fine but the problem is that it is displaying even the empty spaces as paragraph.
Is there a way to eliminate the spaces so that only the text from the Word file is displayed in the text box ?

It is little urgent, can anyone please help me.

Thanks

Posted 29-Aug-12 5:21am

himanshu_88

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)

Maciej Los · Answer 1 · 2012-08-29T08:37:00

Solution 2

The Christian's Amado answer is very good, but after your comments, i recomend you to read about String methods[^], especially: Substring[^], Replace[^] and many others.
You can see the old MS Visual Basic methods too: Left[^], Right[^], Mid[^].

For example, to replace Chr(13) with "" (empty string), use this:

VB

Dim sTmp as String = String.Empty
'inside the loop
sTmp = Trim(p.Range.Text)
sTmp.Replace(Chr(13),"")

Posted 29-Aug-12 8:37am

Maciej Los

Comments

Christian Amado 29-Aug-12 15:46pm

Nice answer!

Maciej Los 29-Aug-12 15:48pm

Thank you, Christian ;)

Christian Amado 29-Aug-12 15:49pm

You're always welcome :)

Christian Amado · Answer 2 · 2012-08-29T05:27:00

Solution 1

For empty string use Trim() Method. This method removes all spaces in a particular string.

http://msdn.microsoft.com/en-us/library/t97s7bs3.aspx[^]

Hope it helps in any way.

Posted 29-Aug-12 5:27am

Christian Amado

Updated 29-Aug-12 5:37am

v3

Comments

himanshu_88 29-Aug-12 11:35am

will i be able to use trim() to delete all the spaces from an entire word document ?

Christian Amado 29-Aug-12 11:36am

http://msdn.microsoft.com/en-us/library/t97s7bs3.aspx

Maciej Los 29-Aug-12 11:44am

If you load data in a loop (thrue the collection of paragraphs), you need to cut spaces for each paragraph.
TextBox1.Text = TextBox1.Text + Trim(p.Range.text)

himanshu_88 29-Aug-12 12:10pm

hi, i tried this code but it is not removing the spaces.
The empty spaces are still being shown on the text box as paragraphs.

Maciej Los 29-Aug-12 12:28pm

Two reasons:
1) Trim deletes only starting and ending spaces. So, if you would like to delete spaces inside of text (between words) you need to iterate through the collection of signs in a text.
2) Each paragraph has (at the end of text) the sign: Chr(13)

himanshu_88 29-Aug-12 12:56pm

Actually i don't want to delete spaces between words, what i want is to delete spaces between paragraphs.
I am using the below code(its just the for loop) to read data from a Word file, paragraph by paragraph and then display it into a text box on the form. But the spaces which are present between paragraphs are also being displayed on the text box(as the code is treating it as a paragraph).
Therefore, is there anything how i can filter out the spaces(or even some special characters) and then remove them before displaying in the text box.

For Each p In currentDocument.Paragraphs
Next p

Maciej Los 29-Aug-12 15:49pm

Wow, my previous vote (5) and comment disappear ;(

5 of course!