Replace <null> items in a list with a Zero value?

Replies to This Discussion

Permalink Reply by Danny Boyes on December 10, 2009 at 5:57am

Not sure if this is the most efficient way but it does achieve the desired effect.
1) Identify the Null Items [Logic>List>Null Item]
2) Create a SERIES numbering 0 to n, where n is the list length
3) Dispatch both lists equally using the boolean pattern from the Null Items
4) Generate the right number of ZEROs to replace the NULLs
5) MERGE each dispatched list together so that the ZEROs are tagged on the end (similar with the indices)
6) Sort the Indices List and Synchronously sort the original Merged list
7) Simplify tree (same as original structure)

A Similar approach can be taken to find a specific value and then replace eg find 0 and replace with 0.1

NB the graft tree component is redundant since I flattened the inputs to the Merge component.

• ▶ Reply

Permalink Reply by Ben Compton on December 10, 2009 at 7:52am

Thanks a million. Worked great

• ▶ Reply

Permalink Reply by Arthur Mani on February 23, 2012 at 2:36am

Hi Danny,

Is there a way to do this with a branched list?

Struggling to adapt it or come up with a simple alternative...

Many thanks,

Arthur

• ▶ Reply

Permalink Reply by Danny Boyes on February 23, 2012 at 2:51am

Hi Arthur,

This is how I would approach replacing Nulls now. The key change is that since 2009!!! the List Replace Component has come along.

Danny

• ▶ Reply

Permalink Reply by Arthur Mani on February 23, 2012 at 5:42am

Thanks a lot Danny, very helpful as always!

Hello from Tel Aviv :) 

• ▶ Reply