The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 03-06-2008
dolo21taf dolo21taf is offline
Registered User
  
 

Join Date: Feb 2008
Posts: 6
CSV file parsing and validation

I have a CSV file that needs to through two seperate processes (in the end there will be 2 files (Dload.unl and Tload.unl and we'll say the input file name is mass.csv). I have a processfile() function that will call the process Dload funtion. In Dload I want to read mass.csv into Dload and then do the following:

1. remove the 6th element in the array (or the last column)
2.validate the format is mm/dd/yy
3.validate that elements 0-4 are NOT NULL
4.write @line to Dload.unl seperated by pipes (with a pipe at the end of the line)

In Tload I want to read mass.csv into Tload and then do the following:
1. Add 3 columns to the file with the following information in each column:
- @output[0] = 0
-@output[1] = Today's Date (in the format 2007-11-07 00:00:00)
-@output[2] = "A"
2.write @line to Dload.unl seperated by pipes (with a pipe at the end of the line)
Thanks in advance, I really appreciate it.

Here is an example of the input file:
0,2007,A,MassLd,7,106,212,314,81,y,

0,2008,B,MassLd,8,107,213,315,82,x,

0,2009,C,MassLd,9,108,214,316,83,z,

0,2006,D,MassLd,6,109,215,317,84,u,


If you need anything else just let me know or have any questions on it.
S