creating Linux script that read in a csv file and output the data in a different format

@TBOne the output would be used for Lawson payroll system.
Thanks, i just started learning Bash scripting, i will look into perl and Python as well

When i excute the script i get this lines of error, is there a reason perl isn't work for me?


tondsd06:dcapps> fileRead.sh Monthsal.csv
Can't locate Time/Piece.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl .) at ./fileRead.sh line 4.
BEGIN failed--compilation aborted at ./fileRead.sh line 4.




if i do

#!/bin/bash    ---- This works

But

#!/usr/bin/perl   ----- Does not work

@Firerat, i'm still getting same error with code

 The Error 
tondsd06:dcapps> fileRead.sh Monthsal.csv
./fileRead.sh: line 13: printf: 3 9 2019: invalid number
: invalid numberine 13: printf: 209299
750-85665-3 0000233420 000000000000000000
./fileRead.sh: line 13: printf: 3 9 2019: invalid number
: invalid numberine 13: printf: 285615
750-85665-3 0000233417 000000000000000000

does that code have the No. of field checks in it?

I also included some debugging bits earlier, to print fields

another

#printf "%s %s %02d%02d%02d%012d\n" \
printf "%s %s _%s_%s_%s_%012d\n" \

but if the "Lawson" can take the original csv without modification ultimately that is what you should use.
I assume some kind of import filter would have to be configured

Originally Posted by jaybiano @TBOne the output would be used for Lawson payroll system. Thanks, i just started learning Bash scripting, i will look into perl and Python as well When i excute the script i get this lines of error, is there a reason perl isn't work for me? Can't locate Time/Piece.pm in @INC (@INC contains: /usr/lib/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 /usr/lib/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl .) at ./fileRead.sh line 4. BEGIN failed--compilation aborted at ./fileRead.sh line 4.

This isn't a shell script (.sh)...this is a perl program, so name if "fileRead.pl" instead. While extensions don't matter to Linux, it *WILL* matter to you later, because you'll need to keep track of things, what they are and what they do. Something like "fileRead" isn't descriptive, so if you put this in a job scheduler, along with OTHER programs, make your life easy. Name it something like "LawsonFileConverter.pl" or something like that.

And you're getting that error because the Time::Piece module for perl isn't installed on your system. You don't say what version/distro of Linux you're using, but chances are it's in the repositories. And *AGAIN* when posting such output, you need to put it in CODE tags.

if i do #!/bin/bash ---- This works But #!/usr/bin/perl ----- Does not work

Define "does not work", please. If you're putting the actual "#!" in front of it, it won't....and if you just run /usr/bin/perl, it will only give you a blank line, since you're entered into the perl compiler...it's expecting you to put in code. Running /bin/bash only brings up a new shell, invisibly...your original shell is still running.

can you also give output of

bash -x fileRead.sh Monthsal.csv

or

#!/bin/bash
input="${1:-./input.csv}"
set -x
while IFS=, read -r -a CSV
do
  [[ ${#CSV[@]} != 5 ]] \
    && echo "error No. of fields incorrect" \
    && break
  [[ ${CSV[0]} =~ ^Account ]] && continue
  #[[ ${CSV[1]} ==  NONREF ]] && continue
  [[ ${#CSV[1]} -lt 10 ]] \
    && CSV[1]="${CSV[1]/#/$(printf "%0$(( 10 - ${#CSV[1]} ))d" 0 )}"
  IFS=/ read -a Date <<<${CSV[2]}
  printf "%s %s %02d%02d%02d%012d\n" \
    "${CSV[0]:0:3}-${CSV[0]:3:5}-${CSV[0]:(-1)}" \
    "${CSV[1]}" \
    "${Date[1]}" "${Date[0]}" "${Date[2]:(-2)}" \
    "${CSV[4]//[.-]}"
exit
done < "${input}"

set -x will show expansions
and exit will exit after first full loop