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

AccuZIP’s Professional Services Team has been a great resource for helping me launch Informed Delivery campaigns for my clients. I am a small direct mail marketing agency specializing in helping my clients find and retain new customers with direct mail. Informed Delivery is the best thing the post office has come up with in my 30+ years in the business. However, just like everything else with the post office, they don't make it easy. AccuZIP has made doing these digital campaigns very simple. I have analyzed campaign results and found the price per click through to the client's website less than an Adword campaign. I am looking forward to working with AccuZIP and their entire Professional Services Team with more clients and campaigns.

S.R., Raleigh, NC