To splits multipe line DB query to display one screen

Help Studio
, , , , , , , , , , , , , ,
1

Hi,

There are multiple queries which are input to process and i’m able to split them query to query.

image
image600×766 59.7 KB

My question is a query writes continuosly into DB as shown as below.

image
image940×289 40.8 KB

But requirment is to display complete query under one screen in oder to take screenshot which should be like this as below

image
image940×256 60.8 KB

Please help to acheive this.

Thanks,

2

@koneruupendra111

There is no UiPath related thing in this…you need to do the settings on your ide for that

Cheers

3

Hi @koneruupendra111 ,

Use assign activity, create string variables say str1,str2,str3,str4

Another assign to concatenate after introducing vbnewline

Str1 + vbnewline + Str2 + vbnewline + Str3 + vbnewline + str4

Use the ConcatenatedString in the type into activity.

Hope this approach works for you.

Since it seems to be oracle db am not sure if this will work,give it a try.

Thanks,
Gautham.

4

@koneruupendra111

Nice idea by him @Gautham_Pattabiraman

A little extension to it if you are getting the query as single string

Then just split the string with 25 charqcters or 50 charqcters and then add newline character between it …ao that any lobg atring converts to thw size you need

Cheers

1 Like
5

Hi @Anil_G /@Gautham_Pattabiraman

Thanks for response

Can you send a sample example in order understand how this works.

Thanks,

6

Hi @koneruupendra111 ,

I am attaching the sample file to under stand the string manipulation logic I had suggested. I have created 2 different sample notepad files one where the string with VbNewline will be written and in another without.

Note : Configure the File path before debugging the workflow, Also instead of writing into a file you can use the string in Type INto as well. It would work just the same.

Hope this helps you understand it better.! Let me know if there is any further help required.
TestProcess.zip (3.2 KB)

Thanks,
Gautham.