HELP- Replace in CSV files

Help
1

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

2

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
3

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

Regards

4

can you provide xaml file for this soluion.