Re: Stripping Carriage Returns/Linefeeds from Flat File

[Richard Tomancikl <Richard_Tomancik@TIGINSURANCE.COM>]

Page 51, SQRW3 Users Guide:
FIXED_NOLF - This file type specifies that all records contained within the
file are the same length with no line terminator (no CR or LF, I checked in
HEX mode).  When writing records, SQR pads short records with the blank
characters to insure each record is the same length.

Just tested the following command syntax and it works.
     open 'c:\temp\test.txt' as 1 for-writing record=20:fixed_nolf

>From a select:
      write 1 from 'Another Record':14

Results:
Another Record      Another Record      Another Record      Another Record
      Anot...................................

Without the line-terminator, it will appear all on one line in any editor.

I had done this before, but not in SQRW yet, so I had to try it.
Richard Tomancik






Wayne Perry <Wayne.PERRY@EDDEPT.WA.EDU.AU> on 01/06/99 08:54:48 PM

Please respond to SQR-USERS@USA.NET

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Richard Tomancik/Consultant/Dallas/TIG)
Subject:  Stripping Carriage Returns/Linefeeds from Flat File




Could anyone suggest the best way to create a fixed length flat file (used
for taxation interfaces) which does not have any carriage return/line feeds
at the end of each record ? Is this possible in Sqr ?  I have not seen any
references to it so I suppose the best option would be to strip out these
characters after the file has been created on our server......

We are running on a Sun/Unix platform.

TIA

Wayne