Changing a specific column of an excel sheet in UiPath

0 votes

Position        URL       Company  Location
Manager  /xyz/123/xyz    AAC      UK
Tester /xyz/132/asd    BBD       UK
architect /xyz/142/asf    CDD       UK

I want to get the urls and add www.xyz.com/ before each of them and remove old url and place new url. my sheet should look like this

Position        URL                  Company  Location
Manager   www.xyz.com//xyz/123/xyz    AAC       UK
Tester  www.xyz.com//xyz/132/asd    BBD       UK
architect  www.xyz.com//xyz/142/asf    CDD       UK
I have made the workflow but dont know how to replace the url

help

Jun 21, 2018 in RPA by wrecker
• 3,090 points
122 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can use a For each row loop to iterate through the data table

replace the value in the url col using Assign activity.

Use Excel application activity and have write range. enter the table inside it

thanks

answered Jun 21, 2018 by Atul
• 5,470 points

Related Questions In RPA

0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16 in RPA by Venkat
• 260 points
1,491 views
0 votes
2 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1. First use the excel application scope ...READ MORE

answered May 16 in RPA by Venkat
• 260 points
1,156 views
0 votes
1 answer

Writing multiple column in excel UiPath

You can read the entire Excel sheet ...READ MORE

answered May 9, 2018 in RPA by wrecker
• 3,090 points
1,041 views
0 votes
1 answer

How to select an item in UiPath that starts with a string

use a wildcard in selector. make sure that ...READ MORE

answered May 21, 2018 in RPA by wrecker
• 3,090 points
757 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
237 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
190 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
776 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
123 views
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by Atul
• 5,470 points
212 views
0 votes
1 answer

UiPath Selector not working in `Type Into` Activity

I only added double quote in selector value in Type ...READ MORE

answered Jul 17, 2018 in RPA by Atul
• 5,470 points
377 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.