Type into activity - how to make it input text with spaces between paragraphs? (text is from excel file)

Help Studio
, ,
1

i guys,

Could you please help me out.

I use type into activity that gets text from excel cell and type it in the web field. I wanted to be with spaces within paragraphs like in Excel.

Example1
This is the 1st paragraph.

This is the 2nd paragraph.

This is the 3rd paragraph.

But UiPath types without spaces. Like that:

This is the 1st paragraph.This is the 2nd paragraph.This is the 3rd paragraph.

What to do?

Thank you in advance.

image
image691×293 20.1 KB

2

Hi,

Do you use ForEachRow activity? The following sample will help you.

image
image675×667 22.7 KB

Or we can also create final sting using the following expression (without ForEachRow).

strData = String.Join(vbCrLF+vbCrLf,dt.AsEnumerable.Select(Function(r) r("Description").ToString))

Regards,

3

Hi @andrey2707

You can give the below syntax in Type Into:

String.Join(vbCrLf+vbCrLf, dt.AsEnumerable().Select(Function(row) row.Field(Of String)("Description")))

image

Regards