# List filtering

**URL:** <https://forum.dynamobim.com/t/list-filtering/1222>\
**Category:** Packages\
**Created:** [March 19, 2015, 8:00pm UTC](https://forum.dynamobim.com/t/list-filtering/1222 "2015-03-19T20:00:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Craig\_Burke](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@Craig\_Burke](https://forum.dynamobim.com/u/Craig_Burke)\
**Post date:** [March 19, 2015, 8:00pm UTC](https://forum.dynamobim.com/t/list-filtering/1222/1 "2015-03-19T20:00:58Z")

</div>

Hi,

I am having some difficulty finding a way to filter information coming out of excel.

I have a long list of sheet numbers and names which have a y/n variable in front, basically i want to filter out the null rows from the ‘y’ rows and produce usable lists for sheet creation.

Thanks in advance.

![Capture](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/9/93a73af209e88fce3fbda830ade69cd9f2d0f45d.png)

&nbsp;

---

<div class="post-metadata">

**Author:** ![Johnes\_Hou](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/johnes_hou/32/9469_2.png) [@Johnes\_Hou](https://forum.dynamobim.com/u/Johnes_Hou)\
**Post date:** [March 19, 2015, 8:18pm UTC](https://forum.dynamobim.com/t/list-filtering/1222/2 "2015-03-19T20:18:52Z")

</div>

You could use ReplaceByCondition node to replace null values.

Put the Object.IsNull on condition input and replace null with your want.

Or use List.FilterByBoolMask node to Remove null values.

like the image blow

![null](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/b/b3d04722db6a5c00c157706d88bba0dd1fc0655f.jpg)

---

<div class="post-metadata">

**Author:** ![Johnes\_Hou](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/johnes_hou/32/9469_2.png) [@Johnes\_Hou](https://forum.dynamobim.com/u/Johnes_Hou)\
**Post date:** [March 19, 2015, 8:42pm UTC](https://forum.dynamobim.com/t/list-filtering/1222/3 "2015-03-19T20:42:11Z")

</div>

And other useful tips for you x[1] means take the list x index 1

you can find more information on Python online Document on

[https://docs.python.org/3/library/stdtypes.html?highlight=list#](https://docs.python.org/3/library/stdtypes.html?highlight=list#)

![null](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/e/eead71a4081038240c583a40adef64f3bfc0c4c5.jpg)

---

<div class="post-metadata">

**Author:** ![Craig\_Burke](https://avatars.discourse-cdn.com/v4/letter/c/94ad74/32.png) [@Craig\_Burke](https://forum.dynamobim.com/u/Craig_Burke)\
**Post date:** [March 19, 2015, 10:48pm UTC](https://forum.dynamobim.com/t/list-filtering/1222/4 "2015-03-19T22:48:19Z")

</div>

Thanks Wy, Exactly what i needed.

---

<div class="post-metadata">

**Author:** ![Mehmet\_Polat\_Diker](https://avatars.discourse-cdn.com/v4/letter/m/f08c70/32.png) [@Mehmet\_Polat\_Diker](https://forum.dynamobim.com/u/Mehmet_Polat_Diker)\
**Post date:** [March 20, 2015, 7:14am UTC](https://forum.dynamobim.com/t/list-filtering/1222/5 "2015-03-20T07:14:26Z")

</div>

Nathan Miller’s LunchBox also has a node for that.  
 ![remove Null](https://cdck-file-uploads-us1.s3.dualstack.us-west-2.amazonaws.com/flex022/uploads/dynamobim/original/2X/0/019ebfcb1eda3fe8971891f9e5aca027ba8cf062.jpg)