|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How can I add a header to a csv file
Post 302248263 by Pablo_beezo on Friday 17th of October 2008 07:50:31 AM
10-17-2008
I have set it like this but the fileout is just as it was going in. The header.sh does not get appended to the file:
HEADER="\"xxxx$OUTFILE_YEAR$INCREMENT\",\"xxxxx\",\"$DATE\",\"$TIME\",\"1\",\"4\",\"$RR\""
echo $HEADER > ../$CUSTOMER_DIRECTORY/header.sh
cat ../$CUSTOMER_DIRECTORY/header.sh >> ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv
Does anyone know why is this not working?
HEADER="\"xxxx$OUTFILE_YEAR$INCREMENT\",\"xxxxx\",\"$DATE\",\"$TIME\",\"1\",\"4\",\"$RR\""
echo $HEADER > ../$CUSTOMER_DIRECTORY/header.sh
cat ../$CUSTOMER_DIRECTORY/header.sh >> ../$CUSTOMER_DIRECTORY/${FILE_OUT_NAME}${OUTFILE_YEAR}${INCREMENT}.csv
Does anyone know why is this not working?
|
|
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 DEBIAN
vpl2mod
VPL2MOD.1(1) Sword Module Utilities VPL2MOD.1(1) NAME
vpl2mod - tool to convert verse per line source to SWORD module SYNOPSIS
vpl2mod SOURCE PATH [0|1] [0|1] DESCRIPTION
This utility is used to create SWORD module from the verse per line formated source. The resulting module will be saved in the path specified. OPTIONS
[0|1] [0|1] The first option indicates whether to prepend verse references or not. The second option is to indicate whether module is NT only or not. NOTE
With no verse references source file must contain exactly 31102 lines. This is KJV verse count plus heading for the module, testament, book and chapter. An example snippet follows: MODULE HEADER OLD TESTAMENT HEADER GENESIS HEADER CHAPTER 1 HEADER In the beginning... This example implies there must also be a chapter 2 header, Exodus header, New Testament header, etc. If there is no text for the header, a black line must, at least, hold place. With verse references, source file must simply contain any number of lines, that begin with the verse reference for which it is an entry, e.g.: gen 1:0 CHPATER 1 HEADER get 1:1 In the beginning... Authors This manual page was written by Dmitrijs Ledkovs <dmitrij.ledkov@gmail.com> for Debian project but may be used by others. SEE ALSO
SWORD 1.6.2+dfsg 2012-02-22 VPL2MOD.1(1)