Sponsored Content
Top Forums Shell Programming and Scripting Csv file parsing and validating Post 302898066 by SriniShoo on Friday 18th of April 2014 07:31:24 AM
Old 04-18-2014
If both schjema file (conf) and data file (file) as comma separated
Below code will do the job and send eligible records to a file "goodrec" and bad data to "badrec"

Code:
awk -F "," 'NR == FNR {a[NR] = $2; next}
  FNR == 1 {print $0 > "goodrec"; print $0 > "badrec"}
  FNR > 1 {for(i = 1; i <= NF; i++)
  {if((a[i] == "integer" && ($i + 0) == $i) || (a[i] == "string" && $i != "")) {f = 1} else {f = 0};
  if(f == 0) {print $0 > "badrec"; next}} print $0 > "goodrec"}' conf file

 

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
lprm(1B)																  lprm(1B)

NAME
lprm - remove print requests from the print queue SYNOPSIS
/usr/ucb/lprm [-P destination] [-] [ request-ID...] [user...] The lprm utility removes print requests (request-ID) from the print queue. Without arguments, lprm deletes the current print request. lprm reports the name of the file associated with print requests that it removes. lprm is silent if there are no applicable print requests to remove. Users can only remove print requests associated with their user name. See . If a superuser executes lprm and specifies the user operand, lprm removes all print requests belonging to the specified user. The print client commands locate destination information using the "printers" database in the name service switch. See nsswitch.conf(4), printers(4), and printers.conf(4) for details. The following options are supported: -P destination The name of the printer or class of printers (see lpadmin(1M)) from which to remove print requests. Specify destination using atomic or POSIX-style (server:destination) names. See printers.conf(4) for information regarding the naming conven- tions for atomic names and standards(5) for information regarding POSIX. - If a user specifies this option, removes all print requests owned by that user. If a superuser specifies this option, removes all requests in the print queue. Job ownership is determined by the user's login name and host name on the machine from which lpr was executed. See . The following operands are supported. user Removes print requests associated with a specific user. Specify user as a valid user name. This option can only be used by a superuser. request-ID Removes a specific print request. Specify request-ID as the job number (Job) associated with a print request and reported by lpq. See lpq(1B). Example 1: Removing a print request The following example removes request-ID 385 from destination killtree: example% lprm -P killtree 385 The following exit values are returned: 0 Successful completion. non-zero An error occurred. /var/spool/print/[cd]f* Spooling directories and files. /var/spool/lp/* LP print queue $HOME/.printers User-configurable printer database /etc/printers.conf System printer configuration database printers.conf.byname NIS version of /etc/printers.conf printers.org_dir NIS+ version of /etc/printers.conf See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWscplp | +-----------------------------+-----------------------------+ lp(1), lpc(1B), lpq(1B), lpr(1B), lpstat(1), lpadmin(1M), nsswitch.conf(4), printers(4), printers.conf(4), attributes(5), standards(5) Users can only remove print requests associated with their user name. By default, users can only remove print requests on the host from which the print request was submitted. If a superuser has set user-equivalence=true in /etc/printers.conf on the print server, users can remove print requests associated with their user name on any host. Superusers can remove print requests on the host from which the print request was submitted. Superusers can also remove print requests from the print server. Some print servers send cancelation notification to job owners when their print jobs have been cancelled. This notification usually comes in the form of an email message. Cancelation notices cannot be disabled on a Solaris server. 23 Feb 2005 lprm(1B)
All times are GMT -4. The time now is 04:33 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy