Re: [sqr-users] Null characters on input file

["Eric Dimick Eastman" <erice@doxpop.com>]

If you are running on a unix-like platform, you could preprocess the file
with the "tr" utility translating nulls into spaces or "\001".  I don't know
if this fits easily into you operating environment, but it might be cheaper
than rewriting chunks of your SQR code.

Cheers,
Eric

On 9/18/07, Bahney, Barbara J. <rusnakbj@upmc.edu> wrote:
>
> Don - thanks for your suggestions....I'll give them a shot as I have run
> out of options!
>
>
>
> -----Original Message-----
> From: Don Mellen [mailto:donm@ontko.com]
> Sent: Monday, September 17, 2007 10:57 AM
> To: This list is for discussion about the SQR database reporting
> languagefrom Hyperion Solutions.
> Subject: Re: [sqr-users] Null characters on input file
>
> There were some items in the archives about this.  One was for fixed
> length
> records (reading the possible null position into a nemeric var) and the
> other suggested reading the file character by character (involves a
> little
> more "by hand" processing).
>
> You could check out those options.
>
> HTH,
> Don
>
>
> On 9/14/07, Bahney, Barbara J. <rusnakbj@upmc.edu> wrote:
> >
> > I am using a PeopleSoft delivered SQR to read in a file from our bank
> in
> > order to do Check Reconciliation. The file contains null characters
> and
> > when the SQR encounters the first null character it recognizes it as
> > end-of-file and the remaining records on the file are bypassed. Does
> > anyone have any suggestions on how I can get around this?
> >
> > Thanks.
> >
> >
> > Barbara J. Bahney
> > University of Pittsburgh Medical Center
> > Information Services Division
> > Senior PeopleSoft Analyst (HRMS)
> > Forbes Tower - Room 3025-9
> >
> > Email:    rusnakbj@msx.upmc.edu
> > Phone:   412-647-3081
> > Fax:        412-647-4499
> >
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
>
>
>
> --
> -----------------------------------------------------------------------
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
> donm@ontko.com |  "In the beginning, there was nothing, which exploded"
>
>
>
> _______________________________________________
> 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