Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Add header to a .csv file
Top Forums Shell Programming and Scripting Add header to a .csv file Post 302536859 by shruthidwh on Wednesday 6th of July 2011 11:22:55 AM
Old 07-06-2011
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

Code:
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
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split large file and add header and footer to each file

I have one large file, after every 200 line i have to split the file and the add header and footer to each small file? It is possible to add different header and footer to each file? (1 Reply)
Discussion started by: ashish4422
1 Replies

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

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

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

5. Shell Programming and Scripting

add header in each file of folder

My files location Dir=/pp/Output/Test/ I have 100 .txt files on above location. I want add header "pt all" on each file. Sample Text file Hi Kalol Jt all q Output i want lt all Kalol Jt all (2 Replies)
Discussion started by: asavaliya
2 Replies

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

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. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

9. Shell Programming and Scripting

Matching the header of a .CSV file with dynamic field names

I have a .CSV file (frequency - weekly) whose header contains the year-week value in two of the columns which keeps changing every week. For an instance please see below. Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10,Column11,Column12,Column13,201420... (4 Replies)
Discussion started by: dhruuv369
4 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

obd2csv

obd2csv(1)						      General Commands Manual							obd2csv(1)

NAME

       obd2csv - Convert obdgpslogger(1) logs to csv files

SYNOPSIS

       obd2csv [ options ]

DESCRIPTION

       Convert obdgpslogger(1) logs to csv files

OPTIONS

       -o|--out <output filename>
	      Output to this .csv file

       -d|--db <database>
	      Work from logs stored in this database file

       -s|--start <time>
	      Only dump rows more recent than this

       -e|--end <time>
	      Only dump rows older than this

       -z|--gzip
	      gzip compress output using zlib [if available]

       -v|--version
	      Print out version number and exit.

       -h|--help
	      Print out help and exit.

NOT OPTIONS

       These options aren't intended for end-users, they're for the GUI.

       -p|--progress
	      Print out progress. It will occasionally print a number in the range [0..100], indicating progress percentage.

SEE ALSO

       obdgpslogger(1), obd2kml(1), obd2gpx(1), obdsim(1), obdgui(1), obdlogrepair(1)

AUTHORS

       Gary "Chunky Ks" Briggs <chunky@icculus.org>

																	obd2csv(1)
All times are GMT -4. The time now is 09:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy