Replace a string with another string from the entire data table

[Aishwarya_Bhargava]

Hi team

I want to replace a particular string from the entire data table, so how can I do it?

thankyou

[pravin_calvin (pravin kumar)]

Hi @Aishwarya_Bhargava

We can achieve it through LINQ!

Refer the thread below!

Using LINQ to replace specific value in DataTable without For-Each

Hi All I attempted to follow the link to replace some values in one specific column in my dataset. The error message, however, popped up “Option Strict On disallows implicit conversions from ‘String’ to ‘Boolean’”. The LINQ I used in Assign Activity is… dt_Combined.AsEnumerable().Where(Function(a) a.Field(of string)(“PhoneNo”).ToString.Replace(“-”, ””).ToString).CopyToDatatable() Would be greatly helpful to advise me what triggers the error message… Thanks in advance!

Regards

[Aishwarya_Bhargava]

This is giving me error

[pravin_calvin (pravin kumar)]

Hi @Aishwarya_Bhargava

Can We have a expected Output Screenshot??

Read range the excel !

Create Datatable Variable.

Assign:DtVariable= readDT.clone

Use the Below LINQ Function!

assign activity:
left side dtCorrected (datatype: Datatable)
rigth side:
(From d in ReadDt.AsEnumerable()
let ra = d.ItemArray.Select(Function (x) x.toString.Replace(“YourValue”, ”ReplaceValue”)).toArray
Select rc = DtVariable .Rows.Add(ra)).CopyToDataTable

Cheers
@Aishwarya_Bhargava

[Aishwarya_Bhargava]

first 2 rows are input and second 2 are output

[Aishwarya_Bhargava]

it worked
thankyou

[Aishwarya_Bhargava]

@pravin_calvin
i want to replace multiple strings with other multiple strings
so how can I do that in a single take

[pravin_calvin (pravin kumar)]

Hi @Aishwarya_Bhargava

Can we have a sample input and output ScreenShot?

Whether you need to replace in one column Value or Multiple Value Column!

Regards

[Parth_Doshi]

Hey @Aishwarya_Bhargava

Check if following this steps helps you

1. Read data table
2. Use output data table activity this convert data table to string
3. Use assign to replace the text you want to replace
4. User Generate data table activity to generate data table from string variable
5. Write the data table back to excel file

Let me know if you face any issues in this.

[Aishwarya_Bhargava]

the generate data table is giving me all the columns in a single row, how can I fix it

[Parth_Doshi]

Can you share the workflow here if possible? @Aishwarya_Bhargava

[Aishwarya_Bhargava]

i can but it has variables attached to the configuration file
so I am not sure how it will be useful
Automatic.xaml (21.8 KB)

[Parth_Doshi]

In Column Separator of Generate Data Table I see you have used comma did you try changing it some other options and see if it is working as expected?

Also, keep this option checked and see if it works @Aishwarya_Bhargava

[Aishwarya_Bhargava]

it worked thankyou

[Parth_Doshi]

Awesome @Aishwarya_Bhargava