set var lastline = (srpl(.lastline, ' ', '',0))
----- Original Message -----
From: "Paul Patrick - Enrollment Management" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, January 06, 2009 12:16 PM
Subject: [RBASE-L] - 0 filling fixed length numeric field for fixed length text
outputfile
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]<mailto:[email protected]>
Web - www.elmcity.org<http://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.
