How to remove the blank lines from output?

Help Activities
, ,
1

Hi guys,

I’m asking first time here for solution please help me.

created the seq for scrapping the recipe’s ingredients. for this, I used the get full text activity but in output showing the lots of blank space between the ingredients.

please help me…

2

Hi @pratiksha_gulhane

Try this

filteredText = String.Join(Environment.NewLine, inputText.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries))

Or

filteredText = System.Text.RegularExpressions.Regex.Replace(inputText, "\s+", " ").Trim()

Regards,

3

just share with us some sample input e.g. use quickly the immediate panel and type in your variablename

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

we would like to inspect as we have to replace multiple line breaks or multiple spaces …

4

Get Full Text is a classic activity. You should be working in modern.

Anyway, Get Text is probably not the best way to do this. Have you tried Table Extraction? For Each UI Element?

5

Hie @pratiksha_gulhane for scrapping the data you can use table extraction activity… any way btw. if your string value has blank space you can use Replace manipulation …
example - create a string variable -

image
image691×123 7.54 KB

image
image
str - input(your get text output).replace(" “,”")
cheers Happy Automation

6

I am not using the table extraction here. using the get full-text classic activity and dynamic selector.

7

I used the replace manipulation here but it still has no change.

8

@pratiksha_gulhane

Can you please provide input and expected output

Regards,

9

yeah, sure. I can share the current output ss here.

A message box displaying a list of 12 ingredients for a recipe, including Granny Smith apples, caster sugar, ground cinnamon, morello cherries, cornflour, butter, plain flour, brown sugar, rolled oats, and shredded coconut. (Captioned by AI)
A message box displaying a list of 12 ingredients for a recipe, including Granny Smith apples, caster sugar, ground cinnamon, morello cherries, cornflour, butter, plain flour, brown sugar, rolled oats, and shredded coconut. (Captioned by AI)885×1072 13.6 KB

10

@pratiksha_gulhane

Try this

Input.ReplaceLineEndings(“”)

Regards,

1 Like
Forum Engagement Daily Reports
11

Give a try at

Assign activity:
strCleansed =

System.Text.RegularExpressions.Regex.Replace(yourTextVar, "[\r\n]+", Environment.NewlIne)

you can prototypw within the immediate panel

After that we can trim the multiple spaces by
strCleansed2 =

System.Text.RegularExpressions.Regex.Replace(strCleansed, "\ +", " ")
12

thank you. this code is working…

after using ReplaceLineEnding
after using ReplaceLineEnding542×667 13.2 KB

13

@pratiksha_gulhane

Try this

System.Text.RegularExpressions.Regex.Replace(Input, "\s+", Environment.NewLine)

The image shows a sequence in an automation workflow where an input text is assigned to the variable "Input," a regular expression operation is performed, and the output is displayed in a message box. (Captioned by AI)
The image shows a sequence in an automation workflow where an input text is assigned to the variable "Input," a regular expression operation is performed, and the output is displayed in a message box. (Captioned by AI)949×612 23.6 KB

Regards,

14

we stressed the scenario with

  • multiple spaces
  • multiple linebreaks
  • multiple linebreaks, spaces and tabs mixed:

and came up to this first cleansing pattern

The image shows a regular expression tool being used to match and substitute newline characters and spaces in a list of ingredients, resulting in formatted text. (Captioned by AI)
The image shows a regular expression tool being used to match and substitute newline characters and spaces in a list of ingredients, resulting in formatted text. (Captioned by AI)1010×916 43.7 KB

Done in UiPath:

grafik
grafik615×638 14.7 KB

strText = System.Text.RegularExpressions.Regex.Replace(strText,"(\r?\n\s+)", Environment.NewLine)

For a cleansing on multiple spaces we can do afterwards
grafik

strText = System.Text.RegularExpressions.Regex.Replace(strText,"(\ +)", " ")

When text comes from web extractions then maybe we would also cleanse all non-breakable spaces ( chr(160) ) in advance

15

output showing below

output
output136×922 4.2 KB

16

thanks for code @ppr
solution -
strText = System.Text.RegularExpressions.Regex.Replace(strText,“(\r?\n\s+)”, Environment.NewLine)

17

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