Hi All,
Have excel with below values
Want to replace Primary - 1 to Primary and Primary - 2 to Secondary.
Thanks,
Ula
Hi All,
Have excel with below values
Want to replace Primary - 1 to Primary and Primary - 2 to Secondary.
Thanks,
Ula
Hi @Boopathi
say row(“UploadedName”).ToString=“Primary” and the same for secondary based on condition
Thanks
Ashwin S
Hi @Boopathi,
Kindly follow the steps below.
On the Top of what everyone suggested - The same can be done for all values at once using UI Automation
Take Two Type into activities and Type values Primary 1 in Find what and Primary in Replace With
Click on Replace all.
Repeat the same for Primary 2 and Secondary.
OR
use BalaReva Custom Excel Activity . Below is link for Same
–
Mukesh
In For Each Row:
row("UploadedName") = row("UploadedName").ToString().Replace("Primary - 1", "Primary").Replace("Primary - 2", "Secondary")
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.