Replace Cells In A Collection With Blank Values

Input collection: myOrders49

OrderID	Item	UnitsOrdered	CostPerUnit
1001	Notebook	25	2.5
1002	Crayons		8.62
1003	Binders	10	13.34
1004	Pencils	21	1.5
1005	Erasers		0.89

Output collection: mySolution49

OrderID	Item	UnitsOrdered	CostPerUnit
1001	Notebook	25	2.5
1002	Crayons	0	8.62
1003	Binders	10	13.34
1004	Pencils	21	1.5
1005	Erasers	0	0.89

Solution code:

//Create a collection
ClearCollect(myOrders49,
{OrderID: 1001, Item: "Notebook", UnitsOrdered: 25, CostPerUnit: 2.5},
{OrderID: 1002, Item: "Crayons", UnitsOrdered: Blank(), CostPerUnit: 8.62},
{OrderID: 1003, Item: "Binders", UnitsOrdered: 10, CostPerUnit: 13.34},
{OrderID: 1004, Item: "Pencils", UnitsOrdered: 21, CostPerUnit: 1.5},
{OrderID: 1005, Item: "Erasers", UnitsOrdered: Blank(), CostPerUnit: 0.89}
);

//Replace cells with missing or blank values code
ClearCollect(mySolution49,myOrders49);
UpdateIf(mySolution49,UnitsOrdered=Blank(),{UnitsOrdered:0});