Sponsored Content
Top Forums Shell Programming and Scripting Csv file parsing and validating Post 302898905 by shree11 on Friday 25th of April 2014 03:28:09 AM
Old 04-25-2014
Hi Srini,

It's working fine. Thank you so much for your support and help.

Regards,
Shree

---------- Post updated 04-25-14 at 02:28 AM ---------- Previous update was 04-24-14 at 11:25 PM ----------

Hi,

One more thing. I also wanted to display the column headers for the badrec file as well.
I'm witting the above code in a bash script. Once i write the good and bad to the goodrec and badrec files and finally i'm moving the goodrecs and badrec on Hadoop HDFS. Once the process is complete it should show the sucess message, count of goodrecs and badrec records on the console. Also it should display the HDFS path where i'm storing the file. How this can be done.How the print statement written in the script file will display the result on the console
Below is my script file :
Code:
#!/bin/bash
awk -F "," 'NR == FNR {h = (h == "") ? $1 : (h FS $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"}' df.txt df.txt
hadoop fs -put /home/hduser/validate/badrec /user/hduser/Dataparse/
hadoop fs -put /home/hduser/validate/goodrec /user/hduser/Dataparse/

If i excecute the ablove code the goodrec and badrec are dumped on HDFS in the below path
Quote:
/user/hduser/Dataparse/
And on the console i would like to get :
Quote:
Parsing is Success
Count of Goodrec : 3
Count of badrec : 4
Validated records are found on the path "/user/hduser/Dataparse"
Please help me how this can be done ?
 

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
ITECONFIG(8)						    BSD System Manager's Manual 					      ITECONFIG(8)

NAME
iteconfig -- modify console attributes at run time SYNOPSIS
iteconfig [-i] [-f file] [-v volume] [-p pitch] [-t msec] [-w width] [-h height] [-d depth] [-x offset] [-y offset] [color ...] DESCRIPTION
iteconfig is used to modify or examine the attributes of the console bell and bitmapped console display. The console bell's volume, pitch, and count may be specified, as well as the bitmapped display's width, height, horizontal and vertical offset, pixel depth, and color map. The following flags are interpreted by iteconfig: -i After processing all other arguments, print information about the console's state. -f Open and use the terminal named by file rather than the default console /dev/ttye0. -v Set the volume of the console bell to volume, which must be between 0 and 63, inclusive. -p Set the pitch of the console bell to pitch, which must be between 10 and 1399. -t Set the duration of the beep to msec milliseconds which must be between 1 and 5000 (5 seconds). -w Set the width of the console display to width pixel columns. Width must be a positive integer. -h Set the height of the console display to height pixel rows. Height must be a positive integer. -d Set the number of bitplanes the console view should use to depth. For example, if depth is 3 then 8 colors will be used. -x Set the horizontal offset of the console view on the monitor to offset pixel columns. The horizontal offset may be a positive or a negative integer, positive being an offset to the right, negative to the left. -y Set the vertical offset of the console view on the monitor to offset pixel rows. The vertical offset may be a positive or a negative integer, positive being an offset down, negative up. Any additional arguments will be interpreted as colors and will be used to supply the color values for the console view's color map, starting with the first entry in the map. (See the COLOR SPECIFICATION section of this manual page for information on how to specify colors.) If more colors are supplied than are usable by the console view, a warning is printed and the extra colors are ignored. COLOR SPECIFICATION
Colors are hexadecimal numbers which have one of the following formats: 0xRRGGBB RR, GG, and BB are taken to be eight-bit values specifying the intensities of the red, green and blue components, respectively, of the color to be used. For example, 0xff0000 is bright red, 0xffffff is white, and 0x008080 is dark cyan. 0xGG GG is taken to be an eight-bit value specifying the intensity of grey to be used. A value of 0x00 is black, a value of 0xff is white, and a value of 0x80 is a grey approximately half way in between. 0xM M is taken to be the one-bit monochrome value to be used. A value of 0x1 is black, and a value of 0x0 is white. BUGS
The iteconfig command is only available on the amiga and atari ports. BSD
February 3, 1994 BSD
All times are GMT -4. The time now is 08:54 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy