Replace new Line with space

[shreyaR (Shreya Rao)]

Hi,

I have this value

Reason for Leaving
Job search for a full time job in the bank while taking a ABC
PAPERS

I want this in single line so I used replace funtion to replace newline with space using vbnewline, System.Environment.newline , vblf but nothings working

Please suggest a solution if anyone has

[NIVED_NAMBIAR (NIVED N)]

Hi @shreyaR

Try this

String.Join(" " ,Split(input,Environment.NewLine))

where input is the string provided as input

Hope it helps you

Mark it as solution if it resolves your query

Regards
Nived N

Happy Automation

[alexandretperez (Alexandre Toledo Perez)]

Any of these should be work:

Assign:

value = value.Replace(Environment.NewLine, " ")
OR
value = value.Replace(vbCrlf, " ")
OR
value value.Replace(vbNewLine, " ")

If none of them work, write your content to a text file and open it on NotePad++. There, go to “View > Show Symbol > Show All Characters” and confirm that what you see is:

Maybe another symbol is causing the issue.

[shreyaR (Shreya Rao)]

@NIVED_NAMBIAR

String.Join(" " ,Split(input,Environment.NewLine))

I didn’t solve the issue

[NIVED_NAMBIAR (NIVED N)]

It works for me fine

What error u are facing?

[Manish540 (Manish Shettigar)]

@shreyaR

Reason for Leaving
Job search for a full time job in the bank while taking a ABC
PAPERS

Use this below code, @shreyaR
System.Text.RegularExpressions.Regex.Replace( InputValue.Trim,“\n”," ")

Hope this may help you

[AhmetALTIN]

thank you very much

[anjasing (Anjali)]

finally after all it’s working…thank u so much