Could someone help me with this? It's urgent

[anjasing (Anjali)]

Extracting cell value having maximum character in a column of a table

Hi All, I want to extract the value of the cell in below Description column with maximum characters For e.g. in below Excel table I want to get Description (mnopqrstyuvvvvvvvvvv abcdeeded pqrst) as my output variable value. If anyone can help?? [Excel table]

[athira.somasekharan]

Hello @anjasing ,

Change the if condition like this:
row(“Description”).ToString.Length > errorDescription.Length

Thanks!

[ptrobot]

If your data table is called dt you can get the longest description with an Assign activity:

longestDescription = dt.AsEnumerable.OrderByDescending(Function(r) r("Description").ToString.Length).First()("Description").ToString

longestDescription is a string.

[anjasing (Anjali)]

Hi, your code was useful, Can you help with one more thing. In the below table if I just want to extract cell value with status as Error only and then having greatest characters in Description then print only description of that cell value? SOrry for the inconvenience. That would be great help

SampleExcel.xlsx (9.3 KB)

[ptrobot]

Hi!

Change the expression to the following if you only want the longest error description:

longestErrorDescription = dt.AsEnumerable.Where(Function(x) x("Status").ToString.Trim.Equals("Error")).OrderByDescending(Function(r) r("Description").ToString.Length).First()("Description").ToString

[anjasing (Anjali)]

Thank you so much. That was a biggg help