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.edueffective 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.
>
