Help Pelase - I need read specific Number dont'read Text and Empty (Excel)

[alicezona (Maexi CaO)]

I need read specific number dont’read text and empty cell
am beginner i don’t know function in ui path
please teach me

thank you.

[AdryGL.96 (Adrián García)]

Hello,

You can get that value as text and then use the CInt function to convert it to a number:

CInt(“1234”) will convert the text “1234” to the number 1234

[manish.patel]

you can use if condition in for each row loop

condition you can use if variable contains any numbers, go into then loop and add into list,array

[Daniela_Colina]

Hi @alicezona,

You can use Read Range to read your Excel as DataTable and then use LINQ in an Assign to filter out what’s not numeric.
Example (assuming you only want to filter column in position 0)

dt_YourTable.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row(0).ToString) AndAlso Information.IsNumeric(row(0))).CopyToDataTable

FilterTable.zip (50.5 KB)

Best,
Daniela

[freelancer_guri (Gaurav Batra)]

read cell and compare the cell value with regex(0-9). if true then proceed else continue to next iteration.

[alicezona (Maexi CaO)]

thank you.

[alicezona (Maexi CaO)]

wow so great
thank you.

[alicezona (Maexi CaO)]

Great work.

Thank you

[alicezona (Maexi CaO)]

ok maybe to try
thak you