The Feed Doctor and the Numbers Game
This week, “P.” in Meridian, MS, writes:
Dear Feed Doctor,
Most of the time the shipping price data in my inventory contains an actual price, but sometimes it has text, such as “See Site.” However, some shopping providers only accept numeric values for shipping. Can I write a rule that turn these non-numeric values into blanks?
Good news for P: there’s a boolean function called ISNUMERIC, that returns “true” if its input is a number, and “false” otherwise. That means he could create the following rule:
IF(ISNUMERIC($shippingprice),$shippingprice,"")
and then assign that rule to the shipping field in the appropriate templates. Of course, most of our default templates already have a shipping-price formatting rule that does this where appropriate, so the real answer to P’s question is: you don’t have to; we already did it for you! But that wouldn’t be as much fun for you guys to read about, would it?