RE: [sqr-users] Line Terminators on flat files

["Alexander, Steve" <Steve.Alexander@ci.sj.ca.us>]

I don't know how to change the line terminator but here's a solution that
might work:

Open the file for reading with an arbitrary record length (say 1000) as
fixed_nolf.  I'm hoping SQR will treat your carriage returns as ordinary
characters.

Read each record and concatenate them until you have a record with your
separator.  Take everything before the separator as your working record.
Everything after the separator is the beginning of your next working record.
Remember, the file will end without a separator, and you want that working
record too.

-----Original Message-----
From: Peter_Wheeler@gov.nt.ca [mailto:Peter_Wheeler@gov.nt.ca]
Sent: Thursday, February 20, 2003 9:38 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Line Terminators on flat files


Hello,
I am trying to read in a flat file through SQR that has 4 fields, with
the last field being a long datatype. This field is anywhere from 100 to
4000 characters in lentgh. It consists of written paragraphs, including
most ascii characters, as well as numerous carraige returns. My field
separator is a 'pipe' - |. 
I cannot get SQR to properly read these 'long' lines of data as it
believes the CR is the line terminator. Is there a way for us to set the
line terminator to whatever character we want in the SQR?
Thanks

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users