Thanks Mike, Razzak, Bill and James, all the solutions worked great. I used James' for the final version, to maximize the fun.
Paul Paul Patrick, Associate Registrar University of Central Oklaoma [email protected] (405) 974-2336 From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Tuesday, January 06, 2009 11:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: 0 filling fixed length numeric field for fixed length text outputfile 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]<mailto:[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 & nbsp; & nbsp; &n bsp; Paul Patrick, Associate Registrar University of Central Oklaoma [email protected]<mailto:[email protected]> (405) 974-2336 From: [email protected]<mailto:[email protected]> [mailto:[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<http://uco.edu>. All e-mail addresses and Web sites will use uco.edu<http://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. **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.
