Hi Everyone, My data table has about 22000+ record…i want to loop through each row and update value in column logo…we’ll get two values in logo column either number or string…i want to check if it is number then check length of number if length is 1 it should add “000” as a prefix for example if it…

Hey @Deepak_Chawla , Below is the linq (From row In dt.AsEnumerable() Let logo = row("Logo").ToString().Trim() Let length = logo.Length Let updatedLogo = If(Integer.TryParse(logo, 0),If(length < 4, Integer.Parse(logo).ToString("D4"), logo),logo)Select dt.Clone.Rows.Add(updatedLogo)).CopyToDataTabl…

Hi @Deepak_Chawla Try this: updatedDataTable = (From row In yourDataTable.AsEnumerable() Let logoValue = If(Integer.TryParse(row.Field(Of String)("Logo"), 0), Integer.Parse(row.Field(Of String)("Logo")), …

What is logo value and updated logo ?

Hi @Deepak_Chawla The below explanation will clarify all your queries. From row In yourDataTable.AsEnumerable(): This part of the query is creating a sequence of rows from your DataTable named yourDataTable. It allows you to iterate through each row in the DataTable. Let logoValue = If(Intege…

Assumption: As shown above a 1 col only datatable Assign Activity dtCleansed = dtOrig.Clone Assign Activity dtCleansed = (From d in dtOrig.AsEnumerable Let lc = d(0).toString.Trim.PadLeft(4,"0"c) Let ra = new Object(){kc} Select r = dtCleansed.Rows.Add(ra)).CopyToDataTable

working fine…Thank you very much :slight_smile:

If you can explain linq that would be great :slightly_smiling_face: What is D4 ?

Hey @Deepak_Chawla , let me explain u "D" stands for “Decimal.” it specifies that the number should be formatted as a decimal number. "4" specifies the minimum width of the string. If the numberr has fewer digits than the specified length (4 in your case), zeros are added to the prefix to make up…

Number formats Docu [image] Standard numeric format strings - .NET In this article, learn to use standard numeric format strings to format common numeric types into text representations in .NET. Linq Learning [image] [HowTo] LINQ (VB.N…

Hi @Vikas_M , i have to select all columns from the same date basis on logo…how can i incorporate other columns for selection in existing query? Seems like need to add something in updatedlogo

@Vikas_M could you please tell me ?

Need Linq query

Help Activities

ppr (Peter Preuss) November 4, 2023, 4:59pm 10

Number formats Docu

Linq Learning

Forum Engagement Daily Reports

Topic		Replies	Views
Help to form linq query to for updating every cell in datatable Activities uiautomation , activities , question	3	198	April 15, 2024
Need LINQ for a requirement Studio studio , question , activities_panel	15	1287	April 12, 2022
Add New Column Values To A Datatable using existing Column Values And Change Format Of The Entire Column Values to Number (Using Linq - Both The Case) Studio studio , question , tools	4	3705	May 3, 2021
How to convert data table rows to string using LINQ queries? Something Else feedback	14	2849	August 23, 2022
LINQ to update columns in data table Studio studio , question , activities_panel	13	1504	May 8, 2023

Need Linq query

Related topics