Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Csv file parsing and validating
Top Forums Shell Programming and Scripting Csv file parsing and validating Post 302897773 by shree11 on Wednesday 16th of April 2014 12:26:56 AM
Old 04-16-2014
I will let you know what i have tried.
I created one script file called validate.sh
Code:
#!/bin/bash

awk -F"|" ' 
BEGIN {
getline var < "configFile"
getline var < "configFile"
n = split( var , arr , "|" )
for ( i = 1 ; i <= n ; ++i )
{
        if( arr[i] == "Numeric" )
                regexp[i] = "^[0-9][0-9]*$"
        if( arr[i] == "String" )
                regexp[i] = "^[a-zA-Z0-9][a-z[A-Z0-9]*$"
}
}
{
for( i = 1 ; i <= NF ; ++i )
{
        if ( ! match ( $i , regexp[i] ) )
                break;
        if ( i == NF )
                print $0
}
}' dataFile

Here the above code is to validate the datatype. Eventhough in my configuration file if i have only 4 columns and in datafile if i have 5 columns, then 5th column is also coming as output which is not expected.

Here my congiguration file is :
col1|col2|col3|col4
Numeric|String|String|Numeric

And Data file is
col1|col2|col3|col4
510|abc|xxx|450
510|abc11|yyy|350
510|pqr|zz11z|670
312|22a2|439|110
312|qqq|rrr|11a0
3$33|sss|bbbb|110
333|A11ss|aAa|110

Also here i have to check for the NULL and field length conditions.
how it can be done?
Last edited by shree11; 04-18-2014 at 08:03 AM..
 

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

LEARN ABOUT DEBIAN

lr_environment

LR_ENVIRONMENT.IN(1)					  LogReport's Lire Documentation				      LR_ENVIRONMENT.IN(1)

NAME

       lr_environment - Export Lire configuration in shell script form

SYNOPSIS

       eval `lr_environment`

DESCRIPTION

       The lr_environment command is used to import the Lire configuration in Lire shell scripts.

       All of Lire configuration variables will be written in a format that can be evaled by the shell.

       Shell scripts don't usually have to use that command, since it is done by the defaults file sourced by each command.

       The old names used by when the configuration was done in shell script are also exported by this script for backward compatibility.

AUTHOR

	 Francis J. Lacoste <flacoste@logreport.org>

VERSION

       $Id: lr_environment.in,v 1.12 2006/07/23 13:16:33 vanbaal Exp $

COPYRIGHT

       Copyright (C) 2003 Stichting LogReport Foundation LogReport@LogReport.org

       This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

       This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
       http://www.gnu.org/copyleft/gpl.html.

Lire 2.1.1							    2006-07-23						      LR_ENVIRONMENT.IN(1)
All times are GMT -4. The time now is 11:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy