String operation in all the rows of one column

Hi all,
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 astha@gmail.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 :

Split(β€œastha@gmail.com”,"@")(0)

1 Like

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)

@astha_gupta Check this Workflow :
FilterDT.zip (9.6 KB)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.