How to get sqlplus column header once in csv file? Post: 302795101

Sponsored Content

Top Forums Shell Programming and Scripting How to get sqlplus column header once in csv file? Post 302795101 by franzpizzo on Wednesday 17th of April 2013 09:52:50 AM

04-17-2013

Registered User

Hi, this is a a similar solution of matrixmadhan:

Code:

cat spool.txt

         X          Y          Z
---------- ---------- ----------
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3

         X          Y          Z
---------- ---------- ----------
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3


cat spool.txt| grep -v "^.$"| head -2 > header.txt
cat header.txt > final_spool.txt
grep -v -f header.txt spool.txt | grep -v "^.$" >>final_spool.txt

cat final_spool.txt
        X          Y          Z
---------- ---------- ----------
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3
         1          2          3

Try also without dots:

Code:

cat spool.txt| grep -v "^$"| head -2 > header.txt
cat header.txt > final_spool.txt
grep -v -f header.txt spool.txt | grep -v "^$" >>final_spool.txt

Last edited by franzpizzo; 04-17-2013 at 10:58 AM..

franzpizzo

View Public Profile for franzpizzo

Find all posts by franzpizzo

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

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

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

4. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256...

5. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

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

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

9. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07...

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

pescetti

PESCETTI(1)						      General Commands Manual						       PESCETTI(1)

NAME

       pescetti -- Pseudo-Duplimate Generator

SYNOPSIS

       pescetti

DESCRIPTION

       This manual page documents briefly the pescetti command.

OPTIONS

       Here are a list of the available options and what they do. You must specify exactly one from --demo, --generate or --load.

       --help	 Prints the help text

       --demo	 Demonstration mode. Generates one hand with permutations and the tutorial for how to use them.

       --generate=N
		 Generate N random boards

       --load=boards.txt
		 Load boards+analysis from boards.txt

       --load-dds=boards.dds
		 Load boards from boards.dds in dds format

       --load-analysis=tricks.txt
		 Load analysis from tricks.txt

       --permutations=permutations.txt
		 Generate the permutations and save them to the given file

       --curtains=curtains.txt
		 Save curtain cards to file curtains.txt

       --save=boards.txt
		 Save the boards+analysis to boards.txt

       --save-dds=boards.dds
		 Save the boards to boards.dds in dds format

       --save-analysis=tricks.txt
		 Save the analysis to tricks.txt

       --format=html|txt|pdf
		 Set the output mode to the given format

       --title=title
		 Set the title for the output

       --output=hands.txt
		 Print the hands to hands.txt, rather than to standard output

       --stats	 Generate statistics about the set of boards; included in the hands output

       --analyze Run the dds analyzer on the boards and print the resulting numberof tricks (warning SLOW)

       --criteria=
		 A  list of criteria to apply to each generated hand to generate specific hand types.  The list should be space separated and each
		 item may be suffixed with a colon and a (fractional) probability value which can be used to weight the criteria.

		 E.g. --criteria="weaknt:0.8 strongnt:0.5"

		 Valid criteria are: unbalanced weaknt strongnt twont strongtwo weaktwo three twoclubs 4441  singlesuit  twosuits  partscore  game
		 slam game-invite slam-invite jumpshift jumpfit splinter bacon weird

       --probability=factor
		 Generate  hands matching the criteria with only the given probability. Factor is in the range 0 to 1. On each attempt to generate
		 a board it is rejected if it doesn't match the criteria with the given probability.  A factor of about  0.8  gives  roughly  half
		 matching boards

AUTHOR

       This manual page was written by Matthew Johnson <debian@matthew.ath.cx>. Permission is granted to copy, distribute and/or modify this docu-
       ment under the terms of the GNU General Public License, Version 2 as published by the Free Software Foundation.

       On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.

																       PESCETTI(1)