Find and replace set of rules

Hi All. I have been setting individual replace rules in the Assign activity but now I would like this to be user maintained in an excel rule file. Does anyone recommend a way I can set the rules in excel such as:

Find Replace
PA Pennsylvania
NJ New Jersey

Thank you,

one of many approach could be:

  • define the set in an excel
  • readin into a datatable
  • iterate over the datatable and the replacing

Thank you this set me in the right direction. Read range and iterate for each row was a good fit.

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