Input string format

[darshanb.is22]

Main.xaml (106.6 KB)

Is the error occuring because there is a space before the numbers in reviews columns, I tried to replace it using assign but there is no change.

[mkankatala (Mahesh Kankatala)]

Hi @darshanb.is22

Change the code like this

(From row In dtt.AsEnumerable() 
  Order By CInt(row("Reviews").ToString().Trim()) Descending, CInt(row("Price").ToString().Trim()) Ascending
  Select row).CopyToDataTable()

Use trim to avoid the spaces.

Hope it helps!!

[ppr (Peter Preuss)]

You can add trim or used
CInt(row(ColNameOrIndex).toString.Trim)

We recommend not relying on Excel and checking the datatable directly within the immediate panel

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

Similar we had done analysis tasks for dates

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", CultureInf…

we can analyze int32 issues like

dtDataVar.AsEnumerable().Where(Function (x) Not int32.TryParse(x(ColNameOrIndex)toString.Trim)))

[darshanb.is22]

Thank you it worked perfectly!

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @darshanb.is22

Happy Automation!!