Got it to work! It's ugly, but effective (my life story).
Thank you all for your advice.
Brian Test
E-Commerce Analyst
ACCO North America
300 Tower Parkway
Lincolnshire, IL 60069-3640
(800) 222-6462 x3973
(847) 419-4146 FAX
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 1:50 PM
To: [EMAIL PROTECTED]
Subject: Re: Mapping Challenge
Brian,
I have been there -- done this.
Create three fields in your application -- one numeric field for
the integer part of your data, one for the decimal part, and sandwich in a
literal period for your decimal point. Map SAC05 to both data fields in
your application record, and fill the decimal with a period. You will get
truncation warnings, that\'s the price you pay.
Art
\"Test, Brian\" <[EMAIL PROTECTED]> wrote:
> Hi All,
Once again I need to draw upon your expertise. I need your help
with
regards to taking an amount field in the SAC segment (856 document),
and
having it be formatted in such a way that it satisfies our
applications
format requirement. My translator is a Harbinger 4.1/Unix version.
This is what should be sent to us on the SAC segment:
If freight charge is $25.12 the segment will look like:
SAC*C*D240***2512
If freight charge is $25.00 the segment will look like:
SAC*C*D240***2500
My application record should have the translated field look like
00025.12
(leading zeros are required)
My problem is that when I do a translation, I can not get the
leading zeros,
since the translator justifies to the left. Any suggestions?
Thanks again,
Brian Test
E-Commerce Analyst
ACCO North America
300 Tower Parkway
Lincolnshire, IL 60069-3640
(800) 222-6462 x3973
(847) 419-4146 FAX
[EMAIL PROTECTED]
\"WorldSecure\" made the following
annotations on 04/17/01 06:43:21
----------------------------------------------------------------------------
--
[INFO] -- Virus Manager:
This message was scanned with Network Associates Viper,
and no viruses were detected.
============================================================================
==
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
"WorldSecure" made the following
annotations on 04/17/01 14:17:10
------------------------------------------------------------------------------
[INFO] -- Virus Manager:
This message was scanned with Network Associates Viper,
and no viruses were detected.
==============================================================================
=======================================================================
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
