You can find out how to quickly replace data values in a table during transformation here:
http://www.apatarforge.org/forums/viewtopic.php?t=98
(Screenshots are provided.)