Hi team,
How to filter/remove “NULL” word and “321” from excel.
p/s: NULL is a word, not empty cell
column A:
123
321
NULL
123
123
Thank you
My appologies, my question not clear, actually i want to clear each row that contain those value.
Remove less than 100 and value “NULL”
input
column A column B
99 chicken
200 fish
NULL meat
output
column A column B
200 fish
Hi @syaheed22
Use the filter datatable activity approach or try this
dt1= dt1.AsEnumerable().Where(Function(r) r(0).ToString<>“NULL” And Cint(r(0).ToString)>100).CopyToDataTable
No error but nothing happen, can help with the flow?
Im doing like this:
- read range
- filter
- write range
Do I need to do loop for the 2nd option?
Hi @syaheed22
It is an assign activitiy
Just asisgn this and after that write dt1 in another excel which is ur expected result 
It said, ROW not declared.
Hi @syaheed22
sorry just corrected the code
see the above reply
The error, conversion from string “010112021ZH2110” to type ‘integer’ is not valid
input.xlsx (8.8 KB)
My input confidential, but I created Input that same with my scenario.
Hi @syaheed22
Try this assign activity
dt2=(From r In dt1.AsEnumerable
Select If(r("Dollar").ToString.IsNumeric,If(CInt(r("Dollar").ToString)>100,r,Nothing),If(r("Dollar").ToString<>"NULL",r,Nothing))).Where(Function(e) e IsNot Nothing).CopyToDataTable
Then write dt2 in excel using write range
output i got
Main.xaml (12.0 KB)
I got error, it said " ‘isnumeric’ is not member of string". Tried to download the xaml, but didnt work. Maybe because of difference version.
Which version of Uipath studio u are using ?
Version 2018.4.5
Can you screenshot the flow instead? Thank you
Hi @syaheed22
Please refer to the Screenshot of the xaml below.
Use the expression as @NIVED_NAMBIAR suggested
Regards
1 Like
@syaheed22
If ur issue is resolved kindly mark the appropriate answer as solution so that we can close the topic