Sponsored Content
Top Forums Shell Programming and Scripting Matching the header of a .CSV file with dynamic field names Post 302911029 by RudiC on Tuesday 29th of July 2014 04:29:15 PM
Old 07-29-2014
Replace the "stdhead" after the getline with your actual standard header file name.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How can I add a header to a csv file

I have a csv file which has no header. the file has 15 fields and needs to go out with a header of 8 fields. The header content needs to have some variables and some fixed that i have set up: variable header fields OUTFILE_YEAR=`date '+%y'` DATE=`date '+%d%m%y'` TIME=`date '+%H:%M:%S'`... (6 Replies)
Discussion started by: Pablo_beezo
6 Replies

2. Shell Programming and Scripting

Append Header in CSV file

Hi, I create a csv file and the output looks like below Arun,E001 Sathish,E003 Now i need to include the below header and the output should like below Name,Number Arun,E001 Sathish,E003 Please guide me. Thanks (4 Replies)
Discussion started by: Sekar1
4 Replies

3. Shell Programming and Scripting

Matching lines across multiple csv files and merging a particular field

I have about 20 CSV's that all look like this: "","","","","","","","","","","","","","","",""What I've been told I need to produce is the exact same thing, but with each file now containing the start_code from every other file where the email matches. It doesn't matter if any of the other... (1 Reply)
Discussion started by: Demosthenes
1 Replies

4. Shell Programming and Scripting

Add header to a .csv file

Hi, I am trying to add a header record to all the .csv files in a directory. I am using the below sed commnad sed -i '1 i \abc,sam,xyz,tip,pep,rip' xyz.csv but this is not adding the header and I am not getting any error,pls tell me if any thing is wrong in the code. Thanks, Shruthi (2 Replies)
Discussion started by: shruthidwh
2 Replies

5. 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

6. Shell Programming and Scripting

Matching and Merging csv data fields based on a common field

Dear List, I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this: date,hostname,status,color,check 02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
Discussion started by: landossa
3 Replies

7. Shell Programming and Scripting

How to get sqlplus column header once in csv file?

Hi All, Could anyoone please let me know how do I get sqlplus column header once in csv file Scripts are below: cat concreq.sh #!/bin/bash . $HOME/.profile while ; do sqlplus apps/pwd <<-EOF set lines 100 pages 100 col "USER_CONCURRENT_QUEUE_NAME" format a40; --set termout off... (5 Replies)
Discussion started by: a1_win
5 Replies

8. Linux

How do I format a Date field of a .CSV file with multiple commas in a string field?

I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below: column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10 "12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies

9. Shell Programming and Scripting

Match columns from two csv files and update field in one of the csv file

Hi, I have a file of csv data, which looks like this: file1: 1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628 2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies

10. UNIX for Dummies Questions & Answers

Check for empty line at end of a dynamic header in each file

Hi Folks, I have a requirement to develop a shell script. PFB my requirement, Requirement: I need to check an empty line after the end of each header in respective file and if a empty line is present simply echo file OK and if empty line is not present echo "Adding empty line" and add an... (6 Replies)
Discussion started by: tpk
6 Replies
BB-DATEPAGE.CGI(1)					      General Commands Manual						BB-DATEPAGE.CGI(1)

NAME
bb-datepage.cgi - Xymon CGI script to view pre-built reports by date SYNOPSIS
bb-datepage.cgi?type={day,week,month} --url=URLPREFIX [options] DESCRIPTION
bb-datepage.cgi is invoked as a CGI script via the bb-datepage.sh CGI wrapper. bb-datepage.cgi is passed a QUERY_STRING environment variable with the type of time-selection that is desired: Either "day", "week" or "month" can be requested. It will then generate a web form with appropriate day/week/month selection boxes, and based on the users' selec- tion a resulting url is built from the URLPREFIX and the time selection. The browser is then redirected to this URL. The URL is constructed from the URLPREFIX, the type-parameter, the value of the "pagepath" or "host" cookie, and the users' selection as follows: type=day The final URL is URLPREFIX/daily/YEAR/MONTH/DAY/PAGEPATH. type=week The final URL is URLPREFIX/weekly/YEAR/WEEK/PAGEPATH. type=month The final URL is URLPREFIX/monthly/YEAR/MONTH/PAGEPATH. YEAR is the full year (4 digits, including century). MONTH is the two-digit number of the month (01..12). DAY is the number of the day in the month (01..31). WEEK is the ISO 8601:1988 week-number (01..53). PAGEPATH is the current value of the "pagepath" cookie if set; if it is not set but the "host" cookie is set, then this host is looked up in the bb-hosts file and the page where this host is found is used for PAGEPATH. These two cookies are set by the default web-header templates supplied with Xymon. OPTIONS
--url=URLPREFIX This specifies the initial part of the final URL. This option is required. --hffile=FILENAME Specifies the template files (from $BBHOME/web/) to use. The default is "--hffile=report". --color=COLOR Sets the background color of the generated webpage. The default is blue. --env=FILENAME Loads the environment defined in FILENAME before executing the CGI script. --debug Enables debugging output. $BBHOME/web/report_form_daily HTML form template for the date selection form when type=daily. $BBHOME/web/report_form_weekly HTML form template for the date selection form when type=weekly. $BBHOME/web/report_form_monthly HTML form template for the date selection form when type=monthly. $BBHOME/web/report_header HTML header file for the generated web page $BBHOME/web/report_footer HTML footer file for the generated web page ENVIRONMENT VARIABLES
BBHOME Used to locate the template files for the generated web pages. QUERY_STRING Contains the parameters for the CGI script. SEE ALSO
bbgen(1), bb-hosts(5), hobbitserver.cfg(5) Xymon Version 4.2.3: 4 Feb 2009 BB-DATEPAGE.CGI(1)
All times are GMT -4. The time now is 08:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy