04-15-2014
Csv file parsing and validating
Hi,
I have basic knowledge on unix shell scripting(not an expert).
My requirement is reading the csv file using the schema defined in the configuration file and if the condition is not mached then move the unmatched record to a error file and matched good records into other file.
In brief:
Here i'm defining the schema of an input file in normal text file and I'm calling it as configuration file. My configuration file looks like :
col1 integer NN
col2 string
col3 string NN
Also I'm having a data file ( say its a .csv file) and it looks like :
id,name,location
1,John,FL
2,Merry,,
3,Taylor,CA
a,George,MI
So here i need to write unix sript such a way that while reading the csv data file ,it should refer to the configuration file for the datatype and whether that field is NULL or not. If it is not satisfying the condition it should drop that whole record and move for the next row for the validation check.
Here it has to read the 1st row value from the csv file and check the datatype of that value from the configuration file. If the value type of the 1st row is matched with the datatype of the 1st column , then it has to move the matched record into a new file and if unmatched record is found it has to move those error records into an error file.
How this can be done using UNIX shell scripting.
Here my expected result is :
id,name,age
1,John,FL
3,Taylor,CA
Rest of the records are dropped because :
2,Merry,, ---> here 3rd filed is NULL but in configuration file it is NOT NULL(NN)
a,George,MI --> here 1st field value is STRING where in conf file it is INTEGER.
So how this could be achieved in unix script and what are the commands need to be used to do this.
Please let me know if the scenario is not clear.
Thanks,
Shree11
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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
LEARN ABOUT NETBSD
gelf_getmove
GELF_GETMOVE(3) BSD Library Functions Manual GELF_GETMOVE(3)
NAME
gelf_getmove, gelf_update_move -- read and update Elf Move information
LIBRARY
ELF Access Library (libelf, -lelf)
SYNOPSIS
#include <gelf.h>
GElf_Move *
gelf_getmove(Elf_Data *data, int ndx, GElf_Move *move);
int
gelf_update_move(Elf_Data *data, int ndx, GElf_Move *move);
DESCRIPTION
These convenience functions are used to retrieve and update class-dependent Elf32_Move and Elf64_Move structures in an ELF object.
Argument data is an Elf_Data descriptor associated with a section of type SHT_SUNW_move. Argument ndx is the index of the move record being
retrieved or updated. The class-independent GElf_Move structure is described in gelf(3).
Function gelf_getmove() retrieves class-dependent move record at index ndx in data buffer data and copies it to the destination pointed to by
argument move after translation to class-independent form.
Function gelf_update_move() converts the class-independent move information pointed to by argument move to class-dependent form, and writes
it to the move record at index ndx in the data buffer described by argument data. Function gelf_update_move() signals an error if any of the
values in the class-independent representation exceeds the representable limits of the target type.
RETURN VALUES
Function gelf_getmove() returns the value of argument move if successful, or NULL in case of an error. Function gelf_update_move() returns a
non-zero value if successful, or zero in case of an error.
ERRORS
These functions may fail with the following errors:
[ELF_E_ARGUMENT] Arguments data or move were NULL.
[ELF_E_ARGUMENT] Argument ndx was less than zero or larger than the number of records in the data descriptor.
[ELF_E_ARGUMENT] Data descriptor data was not associated with a section containing move information.
[ELF_E_RANGE] A value was not representable in the target type.
SEE ALSO
elf(3), elf_getdata(3), elf_getscn(3), gelf(3)
BSD
August 29, 2006 BSD