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
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:
Hi @syaheed22
It is an assign activitiy
Just asisgn this and after that write dt1 in another excel which is ur expected result
The error, conversion from string “010112021ZH2110” to type ‘integer’ is not valid
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 ?
Hi @syaheed22
Please refer to the Screenshot of the xaml below.
Use the expression as @NIVED_NAMBIAR suggested
Regards
@syaheed22
If ur issue is resolved kindly mark the appropriate answer as solution so that we can close the topic