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…

unfortunately we cannot refer to your sample data. The issue could occur from following: the where method expects an evaluation function (predicate, lambda function) that is returning a boolean currently in the the where block a string is returned from the replace method. give a try on: Assign…

Thank you for replying. The original data (highly confidential) is consisted of some columns such as “PhoneNo”, “Postal Code” which sometimes contains “-”, sometimes not (for instance, 1112223333 or 123-456-7890 or 2223334444). And to join with other DataTable which doesn’t have any “-”, I would nee…

Thank you for answering. Actually this worked well! Just wondering if there’re multiple columns to which I should apply the same logic, am I supposed to duplicate and coy same lines? Or any beautiful way to write…?

hust crosscheck to opening and closing brackets in your statements (maybe share it with us)

Hi, this is the right side (From d In dt_Combined.AsEnumerable() Let ra = d.ItemArray.Select(Function (x) x.ToString.Replace(“-”,“”).ToArray) Select rc = dt_Corrected.Rows.Add(ra)).CopytoDataTable

[image] ppr: (From d in t_Combined.AsEnumerable() let ra = d.ItemArray.Select(Function (x) x.toString.Replace(“-”, ””)).toArray Select rc = dtCorrected .Rows.Add(ra)).CopyToDataTable [image] u2018dem0528: Let ra = d.ItemArray.Select(Function (x) x.ToString.Replace(“-”,“”).ToArray ) ← …

Hi, this works fine! (From d in dt_Combined.AsEnumerable() let ra = d.ItemArray.Select(Function (x) x.toString.Replace(“-”, ””)).toArray Select rc = dtCorrected .Rows.Add(ra)).CopyToDataTable But I need Replace Just in the Column (“Time”) from Dt any Idea? Thanks

@Richard_Calle have a look here and select the matching option for your case: [image] How to Update Data Column Values of a Data Table | Community Blog Check out the different available options for updating data table column values to find the best fitting approach for the own scenario. …

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

Help Activities

NIVED_NAMBIAR (NIVED N) March 3, 2021, 9:31am 3

Hi @u2018dem0528

You can try this in invoke code with dt1 as In/Out argument

dt1.AsEnumerable().ToList().ForEach(Sub(row) row(“PhoneNo”)= row(“PhoneNo”).ToString.Replace(“-”,“”))

Linq query to manipulate a string

Topic		Replies	Views
Replace a string with another string from the entire data table Activities excel , activities , question	15	4959	October 25, 2021
REplacing Values in a column of datatable Academy Feedback datatable , activities , question , lp_developer_adv	8	9058	April 17, 2021
Replace values of a column of datatable with another value Studio studio , question , activities_panel	28	7054	September 1, 2021
Specific Columns Value Replace in the DataTable Studio studio , question , activities_panel	18	1690	August 7, 2023
Linq query to manipulate a string Studio studio , question , activities_panel	8	4347	September 6, 2022

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

Related topics