Re: Strange problem with substr() function and right aligned fields

2009-03-05 Thread Jenda Krynicky
From: "Bill Harpley" > My Comment: this is an obvious approach, with numerous advantages. > However, it requires installation of the BD:Oracle module, which can be > very tricky. > Basically, I started to install and configure all of this (Perl, > DBI,DB:Oracle) on HP-UX 11.31 but after 4 days I

Strange problem with substr() function and right aligned fields

2009-03-05 Thread Bill Harpley
Jenda, Thanks for questioning my method of approach: > I must process the output of an SQL query using Perl. > > I know the column position of the data in the output file, which means > that I am able to calculate the width of each field. > > All of the data in the file is left-aligned to the

Re: Strange problem with substr() function and right aligned fields

2009-03-05 Thread Jenda Krynicky
From: "Bill Harpley" > I must process the output of an SQL query using Perl. > > I know the column position of the data in the output file, which means > that I am able to calculate the width of each field. > > All of the data in the file is left-aligned to the field, except for one > column. >

Re: Strange problem with substr() function and right aligned fields

2009-03-03 Thread John W. Krahn
Bill Harpley wrote: I must process the output of an SQL query using Perl. I know the column position of the data in the output file, which means that I am able to calculate the width of each field. All of the data in the file is left-aligned to the field, except for one column. Basically, in t

Strange problem with substr() function and right aligned fields

2009-03-03 Thread Bill Harpley
I must process the output of an SQL query using Perl. I know the column position of the data in the output file, which means that I am able to calculate the width of each field. All of the data in the file is left-aligned to the field, except for one column. Basically, in the output of the SQ qu