Remove the character if that starts with the value of particular column in excel

Hi,

Can you try the following sample?

dt.AsEnumerable.Where(Function(r) r("Ref_ID").ToString.StartsWith("9")).ToList().ForEach(Sub (r)
    r("Ref_ID")=r("Ref_ID").ToString.SubString(1)
End Sub
)

Sample20240208-1.zip (11.5 KB)

Regards,

1 Like