Remove "NULL" word from excel

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 @syaheed22

use filter datatable activity and use the filter condtion like below!

Regards

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

Hi @syaheed22

Try the below filter expression to get the desired result.

image

Regards

No error but nothing happen, can help with the flow?

Im doing like this:

  • read range
  • filter
  • write range

Hi @NIVED_NAMBIAR

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 :blush:

Hi @NIVED_NAMBIAR

It said, ROW not declared.

Hi @syaheed22
sorry just corrected the code

see the above reply

Hi @NIVED_NAMBIAR

The error, conversion from string “010112021ZH2110” to type ‘integer’ is not valid

Hi @syaheed22

If possible can you share me your excel file here?

Regards

Hi @pravin_calvin

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
image

Main.xaml (12.0 KB)

Hi @NIVED_NAMBIAR

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 @NIVED_NAMBIAR

Version 2018.4.5

Hi @NIVED_NAMBIAR

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

image

Regards

1 Like

@syaheed22
If ur issue is resolved kindly mark the appropriate answer as solution so that we can close the topic