Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Exclude the header row in the file to validate
Top Forums Shell Programming and Scripting Exclude the header row in the file to validate Post 302692057 by bmk on Monday 27th of August 2012 03:24:56 AM
Old 08-27-2012
Exclude the header row in the file to validate
Hi All,

File contains header row.. we need to exclude the header row...no need to validate the first row in the file.
Data in the file should take valid data(two columns)..we need to exclude the more than two columns in the file except the first line.
Code:
email|firstname
a|123|100
b|345
c|456|123|123
d|456
e    456

i need output for the file..
Code:
 email|firstname
b|345
d|456

Thanks,
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies

2. Shell Programming and Scripting

Script to validate file header and trailer

Hi, I need a script that validates a file header/detail/trailer. File layout is: Header - Rec_Type|File_name|File_Date Detail - Rec_Type|field1|field2|field3... Trailder - Rec_Type|File_name|File_Date|Record_count Sample Data: HDR|customer_data.dat|20120709... (7 Replies)
Discussion started by: ash_sh
7 Replies

3. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

4. Shell Programming and Scripting

Test command:Duplicate Header row in Log File

I have a script that is inventorying (not sure if thats a word) my environment. It goes out and pulls Hostname OS, IP, and ENV (dev, prod, etc)..then spits all that to a logfile At the top of my script i have a check to see if the logfile exist. ] || touch $LOGFILE && echo "ENV" "\t"... (3 Replies)
Discussion started by: nitrobass24
3 Replies

5. Shell Programming and Scripting

Add column header and row header

Hi, I have an input like this 1 2 3 4 2 3 4 5 4 5 6 7 I would like to count the no. of columns and print a header with a prefix "Col". I would also like to count the no. of rows and print as first column with each line number with a prefix "Row" So, my output would be ... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

6. UNIX for Dummies Questions & Answers

File Row Line Count without Header Footer

Hi There! I am saving the file count of all files in a directory to an output file using: wc -l * > FileCount.txt I get: 114 G4SXORD 3 G4SXORH 0 G4SXORP 117 total But this count includes header and footer. I want to subtract 2 from the count and get ... (7 Replies)
Discussion started by: gagan8877
7 Replies

7. Shell Programming and Scripting

Exclude the header row while splitting the file

Hi All, i have script like ... "TYPE_ID" "ID" "LIST_ID" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" "18" "52010" "1059" i am using the below code it's not taking the header row. awk -F"\t" -v file=test1.txt -v file1=test2.txt ' { if(... (7 Replies)
Discussion started by: bmk
7 Replies

8. Shell Programming and Scripting

How to display the header of a matched row in a file?

Hi, So I am trying to print the first row(header) first column alongwith the matched value. But I am not sure how do I print the same, by matching a pattern located in the file eg File contents Name Place Jim NY Jill NJ Cathy CA Sam TX Daniel FL And what I want is... (2 Replies)
Discussion started by: sidnow
2 Replies

9. Shell Programming and Scripting

Bash to verify and validate file header and data type

The below bash is a file validation check executed that will verify the correct header count of 10 and the correct data type in each field of the tab-delimited file. The key has the data type of each field in it. My real data has 58 headers in it but only the header and next row need to be... (6 Replies)
Discussion started by: cmccabe
6 Replies

10. Shell Programming and Scripting

Script to validate header in a csv file

Hi All; I am struggling to write a script that validates file header. Header file would be like below with TAB separated TRX # TYPE REF # Source Piece Code Destination Piece Code every time I need to check the txt file if the header was same as above fields if validation success... (6 Replies)
Discussion started by: heye18
6 Replies

LEARN ABOUT DEBIAN

mrtg-ping-probe

MRTG-PING-PROBE(1)					      General Commands Manual						MRTG-PING-PROBE(1)

NAME

       mrtg-ping-probe - ping probe module for Multi Router Traffic Grapher

DESCRIPTION

       mrtg-ping-probe is a ping probe module for MRTG 2.x.  It is used to monitor the round trip time and packet loss to networked devices.  MRTG
       uses the output of mrtg-ping-probe to generate graphs visualizing minimum and maximum round trip times or packet loss.

       mrtg-ping-probe is not run directly, but is called by MRTG as a helper when it needs to determine ping time to a host.

       Act responsibly: do not use mrtg-ping-probe to ping devices without the owner's permission.  Just imagine if 10,000 people decided to  ping
       your hosts!  mrtg-ping-probe is meant to be used within your network to get round trip time performance figures for your network.

OPTIONS

       To  use	mrtg-ping-probe you need to configure MRTG to call it from within the definition of a target host. This is done in the MRTG config
       file, which is usually /etc/mrtg.conf.

       Here's an example snippet: change the target name and IP address to suit your needs.

       Target[your.target.ping]: `/usr/bin/mrtg-ping-probe 123.456.789.123`
       SetEnv[your.target.ping]: MRTG_INT_IP="123.456.789.123" MRTG_INT_DESCR="ping"
       MaxBytes[your.target.ping]: 100
       AbsMax[your.target.ping]: 200
       Options[your.target.ping]: gauge, growright
       YLegend[your.target.ping]: ping time (ms)
       ShortLegend[your.target.ping]: ms
       Legend1[your.target.ping]: Maximum Round Trip Time in ms
       Legend2[your.target.ping]: Minimum Round Trip Time in ms
       Legend3[your.target.ping]: Maximal 5 Minute Maximum Round Trip Time in ms
       Legend4[your.target.ping]: Maximal 5 Minute Minimum Round Trip Time in ms
       LegendI[your.target.ping]:  Max:
       LegendO[your.target.ping]:  Min:

       Pay close attention to the backticks in the first line which tell MRTG to execute the nominated external program. Note also that  you  need
       to use the "gauge" option, since the results of subsequent ping probes are independant values and not an incrementing counter.

SEE ALSO

       mrtg(1).

       The latest release of mrtg-ping-probe can be found on the web at http://pwo.de/projects/mrtg/

AUTHOR

       This manual page was written by Jonathan Oxer <jon@debian.org>, for the Debian project (but may be used by others).

								  April 14, 2003						MRTG-PING-PROBE(1)
All times are GMT -4. The time now is 12:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy