Creating a csv file with header in UNIX Post: 302795121

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",...

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'`...

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. Shell Programming and Scripting

Creating Header & Trailer for bulk volume data file

Hi all, I have a requirement to create a Header &Trailer for a file which is having 20 millions of records. If I use the following method, i think it will take more time. cat "Header"> file1.txt cat Data_File>>file1.txt cat "Trailer">>file1.txt since second CAT command has to read all...

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

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

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

8. Shell Programming and Scripting

Creating your own Header file in awk

whether it is possible in awk to create your own header file like in C if so someone give me awk equivalent for below one $ cat foo.h int add(int a,int b) { return(a+b); } $ cat main.c #include<stdio.h> #include"foo.h" void main() { int number1=10,number2=10,number3; number3 =...

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

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

LEARN ABOUT DEBIAN

xml2

XML2(1) 						      General Commands Manual							   XML2(1)

NAME

       xml2 - convert xml documents in a flat format

       2xml - convert flat format into xml

       html2 - convert html documents in a flat format

       2html - convert flat format into html

       csv2 - convert csv files in a flat format

       2csv - convert flat format into csv

SYNOPSIS

       <xml2|2xml|html2|2html|csv2|2csv> > outfile < infile

DESCRIPTION

       There are six tools. Except csv2 and and 2csv they don't take any command-line arguments.  They are all simple filters which can be used to
       read files from standard input in one format and output it to standard output in another format.

       The flat format used by the tools is specific to these tools.  It is a syntax for representing structured markup in a  way  that  makes	it
       easy  to process with line-oriented tools.  The same format is used for HTML and XML; in fact, you can think of html2 as converting HTML to
       XHTML and running xml2 on the result; likewise 2html and 2xml. (Of course, this isn't how the implementation works.)

SEE ALSO

       This program does normally not include any documentation in form of manpages.  However it has a real excellent documentation online with  a
       lot of example.	In fact this manpage was based on this documentation.

       Please find it on:

       http://dan.egnor.name/xml2/ref

       Examples can be found here:

       http://dan.egnor.name/xml2/examples

AUTHOR

       xml2 was written by Dan Egnor.

       This  manpage  was written by Patrick Schoenfeld <schoenfeld@in-medias-res.com> for the Debian project, but may be used by others under the
       same terms as xml2 is distributed.

BUGS

       Bugs can be reported through the Debian Bug tracking system.

								 7h february 2008							   XML2(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a csv file in awk

Discussion started by: Segwar

2. Shell Programming and Scripting

How can I add a header to a csv file

Discussion started by: Pablo_beezo

3. Shell Programming and Scripting

Append Header in CSV file

Discussion started by: Sekar1

4. Shell Programming and Scripting

Creating Header & Trailer for bulk volume data file

Discussion started by: Raamc