Remove Empty New Line

[NAJAA_BAZILAH]

Hi,
I want to remove all empty newline in the string.
Attached is my text that I want to remove the new line.

I’ve tried few method but all failed and does not change at all. I’m not sure why.

Try method 1

processDetail.Replace(Environment.NewLine+Environment.NewLine,Environment.NewLine)

Try method 2

System.Text.RegularExpressions.Regex.Replace(processDetail, “\n+”, “”)

EXAMPLE.txt (574 Bytes)

[Yamatendo (Constant Roux)]

Hello, have you tried with vbNewLine instead of Environment.NewLine ?
As following : processDetail.Replace(vbNewLine+vbNewLine,vbNewLine)

[Yoichi]

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Replace(strData,"(\r\n\s*){2,}","\r\n")

OR

System.Text.RegularExpressions.Regex.Replace(strData,"(\r\n[^\S\r\n]*){2,}","\r\n")

Regards,

[NAJAA_BAZILAH]

I’ve tried with vbNewLine also not working.

[NAJAA_BAZILAH]

It became like this .
There are few lines that combined together instead.

[Yoichi]

Hi,

Sorry, I had a mistake. Can you try the following?

System.Text.RegularExpressions.Regex.Replace(strData,"(\r\n[^\S\r\n]*){2,}",vbCrLf)

Regards,

[NAJAA_BAZILAH]

This one work!
Can I know is vbCrLf stands for new line ?

[Yoichi]

Hi,

@NAJAA_BAZILAH

Can I know is vbCrLf stands for new line ?

Yes, vbCrLf is Chr(13)+Chr(10) : this is linebreak of WindowsOS.

Constants.vbCrLf Field (Microsoft.VisualBasic)

Regards,

[NAJAA_BAZILAH]

Thank you for the resource and your help on this.
Appreciate it.