Find and replace activity in data table

Help Studio
1

Hello,

How can I find particular string and replace it into another string in the data table.

Thanks
Minal Patil

2

Hey!

could you please show us the input and expected output?

Regards,
NaNi

3

Hey @minal.patil If you know in which column the value is present. Then you can use lookup datatable activity.if the value is present then you can replace that particular value with the value you need and assign that to the datatable.
The output of the lookupdatatable activity will be the row index of the searching value if the value is there or if the value is not there the output will be -1
Thanks and Regards.
Sreejith…

4

run 1st time: find 12051 in data table and replace it into 12051_A.
so now value is 12051_A in data table.
if it’s run multiple time: find 12051 in string"12051_A" and replace into 12051_A, Not 12051_A_A

5

I don’t know column name/number

6

Hey!

Try this:

  1. Read excel - output - DtOut
  2. Take one for each row in data table pass the DtOut
  3. Take one if condition and pass the expression like this
CurrentRow("ColumnName").ToString.Trim.Equals("12051")

In then Block take one assign activity and pass the value like this

Assign ReplaceText = CurrentRow("ColumnName").ToString.Trim.Replace("12051","12051_A")

Use add data row and pass the rows in ArrayOfRows

Regards,
NaNi

7

you can use following syntax

(From r In DT_Data.AsEnumerable Let ra = r.ItemArray.Select(Function (x) x.ToString.Trim.Replace(" ",“NA”)).toArray() Select DT_Data.Rows.Add(ra)).CopyToDataTable()

8

I don’t know column name.

9

image
image716×340 23.1 KB

10

It’s not working.

Error: “Collection was modified; enumeration operation might not execute.”

11

Hi @minal.patil

  1. Use Excel process scope activity

  2. Use excel file activity

  3. Find and Replace activity

image
image475×507 14.1 KB

Regards
Gokul

12

In Client machine there no Microsoft Office installed.

13

Only use Data Table activities.

14

Can me give any example