Sponsored Content
Top Forums Shell Programming and Scripting Csv file parsing and validating Post 302898269 by shree11 on Monday 21st of April 2014 05:46:12 AM
Old 04-21-2014
Sorry for changing the requirement.

When i run the below script it is giving all the records(good and bad) in a badrec file and it is not at all creating the goodrec file.

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

Don't know what's going wrong here.
 

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
LIQUIDSOAP(1)						      General Commands Manual						     LIQUIDSOAP(1)

NAME
liquidsoap - a multimedia streaming language SYNOPSIS
liquidsoap [options] [script|expression] DESCRIPTION
Liquidsoap is a programming language for describing multimedia streaming systems. It is very flexible, making simple things simple but giving a lot of control for advanced uses. Liquidsoap supports audio, video and MIDI streams, and a wide range of input/output operators including Icecast and various soundcard APIs. It can perform a broad range of signal processing, combine streams in various ways, support custom transitions, generate sound procedurally... and all this can be assembled as you wish. Input files can be accessed remotely, or even be synthesized on the fly using external scripts such as speech synthesis. Finally, interaction with a running liquidsoap instance is possible via telnet or socket. Liquidsoap scripts passed on the command line will be evaluated: they shall be used to define the streaming system to be ran. It is possi- ble to pass multiple scripts; they will all be ran successively, and definitions from one script can be used in subsequent ones. A script will be read from standard input if - is given as script filename. Information about scripting liquidsoap is available on our website: http://savonet.sf.net/ If the parameter is not a file it will be treated as an expression which will be executed. It is a convenient way to test simple one-line scripts. When running only one-liners, the default is to log messages directly on stdout rather than to a file. OPTIONS
- Read script from standard input. -- Stop parsing the command-line and pass subsequent items to the script. --debug Print debugging log messages. --dynamic-plugins-dir path Directory where to look for plugins. --errors-as-warnings Issue warnings instead of fatal errors for unused variables and ignored expressions. If you are not sure about it, it is better to not use it. --interactive Start an interactive interpreter. --list-plugins List all plugins (builtin scripting values, supported formats and protocols). --list-plugins-xml List all plugins (builtin scripting values, supported formats and protocols), output as XML. --no-pervasives Do not load pervasive script libraries. --version Display liquidsoap's version. -c, --check Check and evaluate scripts but do not perform any streaming. -cl, --check-lib Like --check but treats all scripts and expressions as libraries, so that unused toplevel variables are not reported. -d, --daemon Run in daemon mode. -f, --force-start For advanced dynamic uses: force liquidsoap to start even when no active source is initially defined. -h plugin Print the description of a plugin, eg. a builtin scripting function. -i Display infered types. -p, --parse-only Parse scripts but do not type-check and run them. -q, --quiet Do not print log messages on standard output. -r filename Process a request. -T, --disable-telnet Disable the telnet server. -U, --disable-unix-socket Disable the unix socket. -t, --enable-telnet Enable the telnet server. -u, --enable-unix-socket Enable the unix socket. -v, --verbose Print log messages on standard output. --conf-descr-key key Describe a configuration key. --conf-descr Show all configuration keys with their documentation. --conf-descr-liqi Show all configuration keys with their documentation in liqi (documentation wiki) format. --conf-dump Dump the configuration state -help, --help Display this list of options SEE ALSO
Our website http://savonet.sf.net/ and the HTML documentation coming with your distribution of liquidsoap. AUTHOR
Savonet team <savonet-users@lists.sourceforge.net> Liquidsoap 1.0.1 June 25, 2012 LIQUIDSOAP(1)
All times are GMT -4. The time now is 05:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy