Find and replace (for each) HELP <3

[gustavo.souza]

Greetings.

I need help to perform the following task:

I want to use Find and Replace within a For Each loop because I need to interact with each one.

For example:

I need it to return A1, then A2, A3, A4, and A5.

I tried this but not work:

[mikesage001]

@gustavo.souza try switching the Find drop down to Replace first and see if you’re able to work from there.

[mikesage001]

@gustavo.souza or it might be easier to create a data table with column headers. Read the range from excel.

Then use that data table to find and replace using a for each data row.

For Each data row
Assign: currentrow(“YourColumnName”) = currentrow(“YourColumnName”).ToString().Replace(“OldValue”, “NewValue”)

Then write the range back to excel with or without the headers.

[Anil_G (Anil Gorthi)]

@gustavo.souza

In whereto search try with Excel.currentSheet.Range(currentrow.FullRangeName)

Cheers

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @gustavo.souza ,
We can use read range to get datatable
then use for each file in data table
use If activity to get value of it then return index of value
regards,

[AJ_Ask]

Hi @gustavo.souza

Take the full sheet in the for each excel row as range

In find range just the CurrentRow & value to find

Find attached flow for your ref:
Find&Replace.zip (32.8 KB)
Hope this helps