I am new to RPA and i wanted to do string operations in one full all the rows of one colmn of excel.
it has @ and i want all the information before @,
for example email@example.com
and i want to extract only astha for all the excel column and replace the column values with this new data.Can u please tell in details by using for loop?
@astha_gupta Can you maybe provide a Sample Excel file and the Expected Output that you need. In this way we can understand and help faster.
Also if you need the data just before @ Then you can try the below :
Hi,yes first tab of the excel is my file and 2nd tab is the expected result.
i wanted to add sl.no. colmn too…
sample16.xlsx (12.7 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.