Facing issues before using data scraping

Help
21

@AnandKumar26 I got output has shown but what i need to be done to get it in to excel.

If i need to use string manipulation could you please tell me what i need to do

image
image867×349 6.3 KB

22

The attached screen string values will be stored in a variable right?

Split that string variable as follows split(yourstringvariable,environment.newline) and store this into an array variable.

Then with that array variable first use a Build Datatable Activity with the column name.

Then using For Each as String Add DataRow to the Datatable you have created.

Once all the value added to the datatable then write that data into an Excel.

Please see attached the screenshot

ScreepScrap1
ScreepScrap11366×704 42.1 KB

ScreepScrap2
ScreepScrap21366×706 46.4 KB

Regards,
AK

1 Like
23

@AnandKumar26 I got the output as expected, thanks a lot for your time.

I will reach out to you for any issues.

24

HI @Karthik_Kulkarni - Great!!! Then please mark this as solution provided to close this query thread.

Regards,
AK