Hey @Komom , could you please let us know exactly what are the extra texts you want to remove from the table under the USD Column? We can then also help you on finding a solution through string manipulations or Regex.
Meanwhile I can guide you one how you can use the For Each Row Activity:
-
Search the For Each Row in Data Table Activity in the activity panel and drag it on to your sequence.
-
Next you will need to specifiy the datatable you want to iterate over. For example, let’s say you have read the Financial Data.xlsx file and have stored that data into a datatable variable named dt_financialData, then you can add this datatable in to the For Each Row in Data Table activity in this manner:
-
So the activity will convert the datatable into Enumerable rows through which you can then access the values in the table. Now if you want to access each value from under the column USD, then inside the loop you can make use of this expression i.e. CurrentRow(“USD”).ToString
This is just a gist of how to use the For Each Row in Data Table activity.
Let us know if you need any help regarding the String Manipulations.