in reply to Re^3: Sybase BCP date formatter
in thread Sybase BCP date formatter

Sorry, I only know Korn Shell... Could you provide an example as I have an immediate need for a solution to my bcp output file issue. Any help would be extremely appreciate. Thx Rob

Replies are listed 'Best First'.
Re^5: Sybase BCP date formatter
by runrig (Abbot) on Dec 16, 2008 at 20:21 UTC
    Create this program and fill in with jwkrahn's code above (untested):
    #!/usr/bin/perl use strict; use warnings; { # Put jwkrahn's code here } for my $file (@ARGV) { fix_bcp_file($file); }
    Call this program with the names of the bcp files you want to fix as arguments. If you want to create a backup of your original files, then change this line:
    local ( $^I, @ARGV ) = ( '', $file );
    to something like this:
    local ( $^I, @ARGV ) = ( '.bak', $file );
      Thanks for you patience. I've created a file ChangeDate1.pl as below as suggested. ##</code>
      ## #!/usr/bin/perl use strict; use warnings; { # Put jwkrahn's code here { my %mons = qw( Jan 1 Feb 2 Mar 3 Apr 4 May 5 Jun 6 Jul 7 Aug 8 Sep + 9 Oct 10 Nov 11 Dec 12 ); my $mon_str = join '|', keys %mons; my $mon_re = qr/$mon_str/; sub fix_bcp_file { my ( $file ) = @_; local ( $^I, @ARGV ) = ( '', $file ); while ( <> ) { s/(^|\|)($mon_re)\s{1,2}(\d{1,2})\s(\d{4})\s\s?(\d\d?):(\d +\d):(\d\d):(\d{3})([AP])M(\||$)/ $1 . sprintf( '%04d-%02d-%02d %02d:%02d:%02d.%03d', $4, $mons{ $2 }, $3, ( $9 eq 'P' && $5 < 12) ? $5 + 12 : ( $9 eq 'A' && $5 +== 12 ) ? 0 : $5, $6, $7, $8 ) . $10 /eg; print; # UPDATED thanks runrig } } } } for my $file (@ARGV) { fix_bcp_file($file); } I've got a 'pipe' deliminated bcp file called test1.bcp. When I issue ChangeDate1.pl test.bcp, I get syntax error at ./ChangeDate1.pl line 22, near "+==" Execution of ./ChangeDate1.pl aborted due to compilation errors. If I ever get this going, what I really need to work with is a comma d +eliminated file rather than pipe. Any suggestions??? Rob ##
      <code>##
        weird. what does /usr/bin/perl -v say (and the first line is #!/usr/bin/perl and not "##", right)? And to change to comma delimited, change instances of \|(backslash pipe) to just ,(comma) in the s/.../.../ statement.