How do i remove the additional line breaks?

Help Forum
,
1

Hi, how can i remove line breaks in cells in my Excel file? I have tried various ways such as Replace(“\r”,“”), Replace(Environment.NewLine, String.Empty), Replace(vbLf,“”) but still can’t get rid of the line breaks and it is getting frustrating.

I believe the line breaks are generated from the Add Data Row Activity which is why i added a replace function in the Add Data Row Activity.

Screenshot as attached.

remove line breaks
remove line breaks1232×433 16.7 KB

2

try using regex

Regex.Replace(yourString, “\t|\n|\r”, “”)

1 Like
3

It works! Thanks for the help!

4

Hi @HainTavuk , I have another query on regard expression, regarding about extracting company name from a pdf file. Can I ask in this thread or would it be better for me to create a new thread?

5

you better open a new thread :slight_smile:

6

Alright. Thanks for the help anyway

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.