in Education by
I have an excel sheet that has a data like this Position URL Company Location Developer /xyz/123/xyz ABC US Manager /xyz/132/asd ASD US Tester /xyz/142/asf ABD US I wish to capture all the url from this sheet and add "www.xyz.com/" before them and replace the old url with the new url so that the sheet becomes like this Position URL Company Location Developer www.xyz.com//xyz/123/xyz ABC US Manager www.xyz.com//xyz/132/asd ASD US Tester www.xyz.com//xyz/142/asf ABD US The work flow that i have till now is 1) Open excel application scope 2) Use read range 3) Use for each row to fetch the url 4) Use assign activity to create a new variable and save the new url in it But i am not able to understand how to replace it Would appreciate any help Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
a For each row you can loop through the datatable and replace the value in column URL using an Assign activity like this: Want to learn UIpath from scratch! Have a look at this video on UIpath provided by Intellipaat: Next, use Excel application scope again. Look for the activity Write range (System > File > Workbook > Write range) and enter the datatable. I recommend you to check Add headers. This will add the datatable to the Excel file selected.

Related questions

0 votes
    I have an excel sheet that has a data like this Position URL Company Location Developer /xyz/123/xyz ABC ... Would appreciate any help Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    How to read an excel sheet and put the cell value within different text fields through UiPath? I have a excel ... help me out please? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I'm trying to do a web data scape on a shopping list at shopgun.com by using the RPA program Ui Path ... striked through Shopping list Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I'm trying to do a web data scape on a shopping list at shopgun.com by using the RPA program Ui Path ... striked through Shopping list Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    Is UiPath robot tool available with free UiPath Community Edition? I tried using UiPath Studio and Orchestrator but I ... the license? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I have tried several ways but somehow they dont look clean; I have a URL file in Excel format (400+ urls in a ... easy way to do it? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    While exploring the Automation tool UiPath Studio, I tried to add an element to the queue. But while executing, it ... . Thank you :) Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am doing a proof-of-concept with Sikuli and SeeShell for a larger RPA project. The problem where I get stuck ... to other machines). Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am using a UIPath data scraping and working fine for multipaging. But, My requirment is get child page data using ... -a-site/7014/6 Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have to put an input on the site from Excel file which I have done successfully. The only thing i got stuck ... as per the Excel file Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am using a UIPath data scraping and working fine for multipaging. But, My requirment is get child page data using ... -a-site/7014/6 Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I have to put an input on the site from Excel file which I have done successfully. The only thing i got stuck ... as per the Excel file Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I understand that it is possible to kick off a process in UiPath, using a powershell script. I do not have ... way of doing it? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I am creating RPA. Text box have some default value. I want to enter my value after clearing that default value ... in for loop. Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    Learning RPA with UIPath. Happily extracting onscreen data from a website, processing it, using it, etc. However, ... this stage :/ Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
...