How to remove "PC-F50A" or "|PC-F50A" or "PC-F50A|" in input excel

Help Activities
, ,
4

@Baby123 , You can use LINQ to replace the values

dt = dt.AsEnumerable().Where(Function(a) a.Field(of string)("yourcolumnname").ToString.Replace("your old value"," your new value").ToString).CopyToDatatable()

EX :

dt = dt.AsEnumerable().Where(Function(a) a.Field(of string)("ColumnL").ToString.Replace("PC-F50A","").ToString or  a.Field(of string)("ColumnL").ToString.Replace("PC-F50A|","").ToString or  a.Field(of string)("ColumnL").ToString.Replace("|PC-F50A","").ToString).CopyToDatatable()
1 Like