|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How can I add a header to a csv file
Post 302248335 by Pablo_beezo on Friday 17th of October 2008 10:22:23 AM
10-17-2008
Hi fpmurphy
i do exactly what you say:
echo $HEADER > ../$CUSTOMER_DIRECTORY/new.csv
cat ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv >> ../$CUSTOMER_DIRECTORY/new.csv
cat ../$CUSTOMER_DIRECTORY/new.csv
the output of the above command (new.csv) is:
"xxxx08","xxxxxxx","171008","15:05:39","1","4"," 232 ../xxxx/xxxxx xxxx_080910.txt"
exactly the same as when it goes in??? it just seems to ignore the ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv ???
see below contents of both files that go in to above command:
contents of new.csv
"xxxx08","xxxxxxx","171008","15:05:39","1","4"," 232 ../xxxx/xxxxx xxxx_080910.txt"
contents of ${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv"
"","ABC","","12345678","","","","","","","","","","","CH1 7DD"
Why is it not working??
Not that it matters but i am in KSH
i do exactly what you say:
echo $HEADER > ../$CUSTOMER_DIRECTORY/new.csv
cat ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv >> ../$CUSTOMER_DIRECTORY/new.csv
cat ../$CUSTOMER_DIRECTORY/new.csv
the output of the above command (new.csv) is:
"xxxx08","xxxxxxx","171008","15:05:39","1","4"," 232 ../xxxx/xxxxx xxxx_080910.txt"
exactly the same as when it goes in??? it just seems to ignore the ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv ???
see below contents of both files that go in to above command:
contents of new.csv
"xxxx08","xxxxxxx","171008","15:05:39","1","4"," 232 ../xxxx/xxxxx xxxx_080910.txt"
contents of ${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv"
"","ABC","","12345678","","","","","","","","","","","CH1 7DD"
Why is it not working??
Not that it matters but i am in KSH
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
4. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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 CENTOS
processcsv.py
PROCESSCSV.PY(1) Virtualization Support PROCESSCSV.PY(1) NAME
processcsv.py - process virt-top CSV files SUMMARY
virt-top --csv data.csv processcsv.py < data.csv DESCRIPTION
virt-top is a top(1)-like utility for showing stats of virtualized domains. processcsv.py is a simple Python script that post-processes the output of "virt-top --csv". It is used like this: virt-top --csv data.csv processcsv.py < data.csv The second command will overwrite the following files in the current directory: "global.csv" This contains the global (host) statistics columns from the CSV file. "domainNN.csv" (multiple files) For each libvirt domain ID NN, a file is created containing the per-domain statistics from the CSV file. SEE ALSO
virt-top(1) AUTHORS
Richard W.M. Jones <rjones @ redhat . com> COPYRIGHT
(C) Copyright 2007-2012 Red Hat Inc., Richard W.M. Jones http://libvirt.org/ This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. virt-top-1.0.8 2013-12-29 PROCESSCSV.PY(1)