Convert Ounces to Pounds of piecelb

In manifest mailings, the piecelb and piecethick fields have a specific way of formatting. If your weight field is in ounces, this command will convert the weight to pounds and add the leading zeros before the implied deciminal

Ounces: 40.81200

piecelb: 0255075

This command makes an weight field and converts the piecelb field from ounces to pounds, then adds the implied leading zeros. piecelb: 6 characters wide \| The weight is a fraction of a pound with leading zeros (ex. 007882 = .7882 lbs) Map ounces (Numeric 10, 5 decimals) to piece weight. Map thickness to piece thickness ************************************************************* Add pounds field and convert imported ounces field to pounds ON ERROR com_Mesg=MESSAGE() SET SAFETY OFF ALTER TABLE ALIAS() ADD COLUMN pounds N(10,5) Replace all pounds with ounces/16 ************************************************************* ALTER TABLE ALIAS() ALTER COLUMN pounds C(10) Remove leading spaces from pounds field Replace all pounds with ALLT(pounds) ************************************************************* Add piecelb field ALTER TABLE ALIAS() ADD COLUMN piecelb C(10) Replace all piecelb with "0"+LEFT(pounds,1)+SUBSTR(pounds,3) ************************************************************* piecethick: 6 characters wide \| Implied decimal is after second character (ex. 025000 = 2.5" thick) Replace all piecethick with "0"+LEFT(ALLT(piecethick),1)+SUBSTR(piecethick,3) Replace all piecethick with PADR(ALLT(piecethick),6,"0") *************************************************************

*This command makes an weight field and converts the piecelb field from ounces to pounds, then adds the implied leading zeros.
*piecelb: 6 characters wide | The weight is a fraction of a pound with leading zeros (ex. 007882 = .7882 lbs)

*Map ounces (Numeric 10, 5 decimals) to piece weight. Map thickness to piece thickness
**************************************************************

*Add pounds field and convert imported ounces field to pounds
ON ERROR com_Mesg=MESSAGE()
SET SAFETY OFF
ALTER TABLE ALIAS() ADD COLUMN pounds N(10,5)
Replace all pounds with ounces/16
**************************************************************

ALTER TABLE ALIAS() ALTER COLUMN pounds C(10)
*Remove leading spaces from pounds field
Replace all pounds with ALLT(pounds)
**************************************************************

*Add piecelb field
ALTER TABLE ALIAS() ADD COLUMN piecelb C(10)
Replace all piecelb with "0"+LEFT(pounds,1)+SUBSTR(pounds,3)
**************************************************************

*piecethick: 6 characters wide | Implied decimal is after second character (ex. 025000 = 2.5" thick)
Replace all piecethick with "0"+LEFT(ALLT(piecethick),1)+SUBSTR(piecethick,3)
Replace all piecethick with PADR(ALLT(piecethick),6,"0")
**************************************************************

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I just want to take a moment and let the folks at Accuzip know what great support I have received from Mathew Little. He has really helped get our IMB Barcode project off the ground! Learning Accuzip has been a pleasant process and the relief of knowing my project will be installed despite the tight deadline is wonderful! I wish there were more like you doing support at other companies when we need them.

M.V., Brentwood, TN