Sponsored Content
Top Forums Shell Programming and Scripting Csv file parsing and validating Post 302898821 by shree11 on Thursday 24th of April 2014 07:56:37 AM
Old 04-24-2014
Hi, If i execute the below code i'm getting all the records in bad file(including good and bad records) and getting only the headers in good file. I'm not getting validated good records along with the headers in good file.
Code:
awk -F "," 'NR == FNR {h = (h == "") ? $1 : (h OFS $1); gsub("[)(]", "-", $2); split($2, a, "-"); d[NR] = a[1]; l[NR] = a[2]; n[NR] = ($3 == "NOT NULL") ? 1 : 0; next}
  FNR == 1 {print h > "goodrec"}
 {for(i = 1; i <= NF; i++)
  {if(((d[i] == "Numeric" && (($i + 0) == $i || $i == "")) || d[i] == "String") && (length($i) <= l[i]) && (length($i) >= n[i]))
      {f = 1} else {f = 0};
    if(f == 0) {print $0 > "badrec"; next}} print $0 > "goodrec"}' cf.txt df.txt

Output getting in the goodrec is :
Quote:
id,name,state,street_No
But the expected output in the goodrec is
Quote:
id,name,state,street_No
22,Lilly,CA,405
55,Taylor,GI,3333
77,,FL,22
Thanks,
Shree
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in parsing a CSV file with Shell script

I have a CSV file which contains number series as one of the fields. Some of the records of the field look like : 079661/3 I have to convert the above series as 079661 079662 079663 and store it as 3 different records. Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Discussion started by: mihirk
10 Replies

2. Shell Programming and Scripting

Parsing a csv file

I am trying to parse a csv file in the below 'name-value pair' format and then use the values corresponding to the name. Type:G,Instance:instance1,FunctionalID:funcid,Env:dev,AppName:appname... (6 Replies)
Discussion started by: chiru_h
6 Replies

3. Shell Programming and Scripting

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... (1 Reply)
Discussion started by: dolo21taf
1 Replies

4. Shell Programming and Scripting

2 problems: Mailing CSV file / parsing CSV for display

I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out! I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies

5. Shell Programming and Scripting

Parsing a CSV File

Hey guys, I'm in the process of learning PHP and BASH scripting. I'm getting there, slowly ;) I would like some help with parsing a CSV file. This file contains a list of hostnames, dates, and either Valid, Expired, or Expired Soon in the last column. Basically, I want to parse the file,... (12 Replies)
Discussion started by: dzl
12 Replies

6. Shell Programming and Scripting

Parsing complicated CSV file with sed

Yes, there is a great doc out there that discusses parsing csv files with sed, and this topic has been covered before but not enough to answer my question (unix.com forums). I'm trying to parse a CSV file that has optional quotes like the following: "Apple","Apples, are fun",3.60,4.4,"I... (3 Replies)
Discussion started by: analog999
3 Replies

7. Shell Programming and Scripting

Parsing a CSV file and deleting all rows on condition

Hello list, I am working on a csv file which contains two fields per record which contain IP addresses. What I am trying to do is find records which have identical fields(IP addresses) which occur 4(four) times, and if they do, delete all records with that specific identical field(ip address). ... (4 Replies)
Discussion started by: landossa
4 Replies

8. Shell Programming and Scripting

Help required in parsing a csv file

Hi Members, I am stuck with the following problem. Request your kind help I have an csv file which contains, 1 header record, data records and 1 footer record. Sample is as below Contents of cm_update_file_101010.csv -------------------------------------------------- ... (6 Replies)
Discussion started by: ramakanth_burra
6 Replies

9. Shell Programming and Scripting

Parsing csv file and pass to a variable

Hi, Newbie here and I need some help to parse a csv file that contains fields separated by ",". What I need to achieve here is, read the 1 line file and extract 240 fields and pass to a variable and then read the next 240 fields and pass to a variable, over and over. If anyone can assist that... (4 Replies)
Discussion started by: tmslixx
4 Replies

10. Shell Programming and Scripting

Help with Parsing a CSV File

Hello All, I have an input CSV file like below, where first row data can be in different position after every run of the tool, i.e. pzTest in below example is in column 1, but it can be also in 3 column and same for all the headers in the first row. pzTest, pzExtract, pxUpdate, pzInfo... (1 Reply)
Discussion started by: asirohi
1 Replies
SVN-BISECT(1)						      General Commands Manual						     SVN-BISECT(1)

NAME
svn-bisect - Bisect Subversion revisions to find a regression SYNOPSIS
svn-bisect start [good_rev [bad_rev]] svn-bisect {good|bad} [rev] svn-bisect run command svn-bisect reset svn-bisect status DESCRIPTION
svn-bisect helps to automate finding a bug or behavior change in a Subversion working copy. Given an initial "good" revision, with the desired or original behavior, and a newer "bad" revision, with the undesired or modified behavior, svn-bisect will do a binary search through the revision range to find which revision caused the change. svn-bisect must be initialized in a working copy, with svn-bisect start. It also needs to be given at least one good revision (the base- line) and one bad revision (known modified behavior) revision. Sub-commands: start Initializes or reinitializes svn-bisect; optionally takes good and bad revision parameters. good rev bad rev Tells svn-bisect that a revision is good or bad, defining or narrowing the search space. If not specified, revision defaults to the current revision in the working copy. svn-bisect will then update to a revision halfway between the new good and bad boundaries. If this update crosses a point where a branch was created, it switches in or out of the branch. reset Resets the working copy to the revision and branch where svn-bisect start was run. In the simple case this is equivalent to rm -r .svn-bisect; svn update, but not if it has crossed branches, and not if you did not start at the HEAD revision. In any case, svn-bisect never keeps track of mixed-revision working copies, so do not use svn-bisect in a working copy that will need to be restored to mixed revisions. status Prints a brief status message. run command Runs the bisection in a loop. You must have already defined initial good and bad boundary conditions. Each iteration through the loop runs command as a shell command (a single argument, quoted if necessary) on the chosen revision, then marks the revision as good or bad, based on the exit status of command. EXAMPLES
Assume you are trying to find which revision between 1250 and 1400 caused the make check command to fail. svn-bisect start 1250 1400 svn-bisect run 'make check' svn-bisect reset ENVIRONMENT
SVN The Subversion command-line program to call (default svn). FILES
.svn-bisect The directory containing state information, removed after a successful bisection. SEE ALSO
git-bisect(1). AUTHOR
Written by Robert Millan and Peter Samuelson, for the Debian Project (but may be used by others). 2009-10-22 SVN-BISECT(1)
All times are GMT -4. The time now is 04:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy