HELP- Replace in CSV files

Hi, i need to replace in csv files but i dont know how, i already do replaces in word files but in that extension not. Anyone can help me or this replace does not works in csv files?

thankyou

I don’t think there is an activity similar to word replace. One way to to is load your csv to DataTable and perform below logic

  1. Read CSV Activity

  2. Read all cells

    foreach (Rowin dtOutput.Rows)
    {
    foreach(Col in dtOutput.Columns)
    {
    Row(col) = Row(col).ToString.Replace(“OldString”,“NewString”);
    }
    }

  3. Write CSV activity

3 Likes

Many thanks VVAIDYA by the quickly answer and the solution you given. Works so fine :slight_smile:

Regards

can you provide xaml file for this soluion.