How to replace non-fixed string value with fixed value

I have value in Excel column and I want to replace that with fixed value.

image

I have this Remark column and not sure what data and how much lines will be updated there everytime, I just want to replace all this remark as “Error” like below.

image

@nilesh.mahajan - You can try the below code in ‘Invoke Code’ activity

dt.AsEnumerable().ToList().ForEach(Sub(row) row(“Remark”)= “Error”)

For Reference please check this post…

thnx Prasath for quick response.
I have used the invoke code activity, but somehow it has not changed anything in excel file or Datatable.

@nilesh.mahajan - After the invoke code activity did you used write range to write the output??

Yes, I was used write range but some mistake from my end.
Now its working fine. thnx for help

1 Like

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