Better still use the following syntax:
SET VAR lastline = ('T1' + (format(.fknt,'[-]000000')) +
(format(.hknt,'[-]000000')) + (format(.lknt,'[-]000000')) +
(format(.wknt,'[-]000000')) + (format(.gknt,'[-]000000')) +
(format(.aknt,'[-]000000')) + (format(.xknt,'[-]000000')) +
(format(.dknt,'[-]000000')) + (format(.totknt,'[-]00000000')) +
(RJS(.filler,642)))
Note!! the syntax '[-]000000' transfers the "+/-" place holder to the end of
the field. Thus when you use the "+" catenation syntax this eleminates the
trailing space reserved for the "+/-" place holder. Also this syntax should be
faster that suggested alternatives.
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
________________________________
From: Bill Downall <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tuesday, January 6, 2009 11:24:05 AM
Subject: [RBASE-L] - Re: 0 filling fixed length numeric field for fixed length
text outputfile
Paul,
Format is leaving room at the left end of the numbers for the minus sign. You
will have to eliminate that. Here are some options:
1) before your WRITE:
SET VAR vLastLine=(srpl(.vLastline,' ',NULL,0))
2) Use LJS() to left-justify each formatted value
('T1' + ljs(format(.fknt,'000000')) + ljs(format(.hknt,'000000')) _ etc.
Bill
On Tue, Jan 6, 2009 at 12:16 PM, Paul Patrick - Enrollment Management
<[email protected]> wrote:
Good morning, all.
I'm creating a student enrollment file to send to the
National Clearinghouse, and trying to 0-fill an output field and concatenate it
to other 0-filled fields.
I'm using the code below
SET VAR lastline = ('T1' + (format(.fknt,'000000')) +
(format(.hknt,'000000')) + (format(.lknt,'000000')) + (format(.wknt,'000000'))
+ (format(.gknt,'000000')) + (format(.aknt,'000000')) +
(format(.xknt,'000000')) + (format(.dknt,'000000')) +
(format(.totknt,'00000000')) + (RJS(.filler,642)))
WRITE .lastline
And the results look like this. An extra space is
being added between fields.
T1 008844 004080 001823 000441 000000 000000 000002
00015192
Any ideas how to get rid of the space or a better way to
accomplish this? I've used LJS and RJS on the fields which
get rid of the extra spaces, but haven't figured out how to 0-fill using
those methods.
Any help would be appreciated.
Paul
Paul Patrick, Associate Registrar
University of Central Oklaoma
[email protected]
(405) 974-2336
From:[email protected] [mailto:[email protected]] On Behalf Of Tom Frederick
Sent: Monday, January 05, 2009 12:47 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Relational Verification
Today,
I had two LAN based tables pop up the error message 'Cannot read table
structure' while running Relational Verification before using Design.
Other LAN tables had no problems with RV or Design. A clone development
database on another drive works just fine. Using 12/29 V8 and did the usual
checks including reload. RV has been ON for several months for no particular
reason. When RV is turned off, the tables popped up immediately and operate /
save like always. My understanding is RV ON checks table structures before
changes and RV OFF checks table structures after saving any changes. Is there a
reason to leave RV ON if OFF seems to work just fine? If these messages are a
sign of something developing, what is a likely solution? I am putting an
Audit system into the Forms for these tables, but have not changed the tables
themselves in a long time.
Tom
Frederick
Elm
City Center
1314
W Walnut
Jacksonville,
IL 62650
Off
- 217-245-9504
Fax
- 217-245-2350
Email
- [email protected]
Web
- www.elmcity.org
________________________________
**ADDRESS CHANGE NOTICE**-The University of Central Oklahoma is moving to a
new Internet address. All e-mail addresses and Web sites are now available at
uco.edu. All e-mail addresses and Web sites will use uco.edu effective January
2, 2009.
**CONFIDENTIALITY**-This e-mail (including any attachments) may contain
confidential, proprietary and privileged information. Any unauthorized
disclosure or use of this information is prohibited.
