Filtering Columns and removing the leading Zeros

[fernando_zuluaga]

Hi @Sisay_Dinku

give a try with the following

dt_input.AsEnumerable.where(function(x) x(“Customer”).ToString.Equals(“CALISUN”) And x(“Store #”).ToString.Equals(“12”) And DateTime.parseExact(x(“Start Date”).ToString,{"M/d/yyyy","dd/MM/yyyy","d/M/yyyy","MM/dd/yyyy","MM/dd/yyyy hh:mm:ss", "dd/MM/yyyy hh:mm:ss"},system.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”).Equals(“01/04/2023”)).CopyToDataTable

to remove leading zeros you can loop and assing a new value like this

CurrentRow("PO #").ToString().TrimStart("0"c).ToString()

Regards!