Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Merge all csv files in one folder considering only 1 header row and ignoring header of all others Post 302566993 by Shiny_Roy on Friday 21st of October 2011 04:00:47 PM
Old 10-21-2011
My input n number of csv files as below.
File1.csv
Header row
data row1
data row11
data row11
....

File2.csv
Header row
data row2
data row22
data row222
....

etc

Filen.csv
Header row
data rown
data rownn
data rownnn
....

My OUTPUT File Should look like
FinalFile
Header row
data row1
data row11
data row11
data row2
data row22
data row222
.....
data rown
data rownn
...
Thanks
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

insert header row into .xls

Hello, I am building an .xls file extracting info from a DB to be eventually emailed. All is good except how do I put in a header row.. like date, name of report etc. before the columns with the actual column name and data? Thanks for any assistance.. the below is after I have signed into... (11 Replies)
Discussion started by: Tish
11 Replies

2. Linux

Reading the header of a tar file(posix header)

say i have these many file in a directory named exam. 1)/exam/newfolder/link.txt. 2)/exam/newfolder1/ and i create a tar say exam.tar well the problem is, when i read the tar file i dont find any metadata about the directories,as you cannot create a tar containig empty directories. on the... (2 Replies)
Discussion started by: Tanvirk
2 Replies

3. Shell Programming and Scripting

Merge text files while combining the multiple header/trailer records into one each.

Situation: Our system currently executes a job (COBOL Program) that generates an interface file to be sent to one of our vendors. Because this system processes information for over 100,000 employees/retirees (and growing), we'd like to multi-thread the job into processing-groups in order to... (4 Replies)
Discussion started by: oordonez
4 Replies

4. UNIX for Dummies Questions & Answers

split header row into one column

So, I have a massive file with thousands of columns I want a list of the headers in one column in another file. So I need to strip off the top line (can use head-1) But how can I convert from this format: A B C D E F G to A B C D E F G (6 Replies)
Discussion started by: polly_falconer
6 Replies

5. Shell Programming and Scripting

Perl array with row header

Here is the csv file file i have: ServerName, IPAddress, Gateway, Notes ServerA, 192.168.1.100, 192.168.1.1, This is some server ServerB, 192.168.1.110, 192.168.1.1, This is some other server ServerC, 192.168.1.120, 192.168.1.1, This is some other other server I would like to have the... (6 Replies)
Discussion started by: Ikon
6 Replies

6. UNIX for Dummies Questions & Answers

Merge Files into Single with Header

Hi All, I am trying to merge all files in a directory that end in *.txt to a single file with the contents one after the other. This I can do using the cat function but how do I put the name of the file as a header for each one in the combined single file and seperate the contents from each... (2 Replies)
Discussion started by: pcg
2 Replies

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

8. Shell Programming and Scripting

Replace a column with a value by ignoring the header lines

i have a file in the gz format , the content of the file is as follow. gzcat f1.gz # 1.name # 2.location # 3.age # 4.dob . . . . . . . . . # 43.hobbies < Aravind,33,chennai,09091980, , , , , , , surfing> (5 Replies)
Discussion started by: aravindj80
5 Replies

9. Shell Programming and Scripting

Merge multiple files with common header

Hi all, Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),, How can I merge them to one singe file "X" in shell scripting Thanks for your suggestions. (2 Replies)
Discussion started by: msarguru
2 Replies

10. Shell Programming and Scripting

Find header in a text file and prepend it to all lines until another header is found

I've been struggling with this one for quite a while and cannot seem to find a solution for this find/replace scenario. Perhaps I'm getting rusty. I have a file that contains a number of metrics (exactly 3 fields per line) from a few appliances that are collected in parallel. To identify the... (3 Replies)
Discussion started by: verdepollo
3 Replies
folder(1mh)															       folder(1mh)

Name
       folder - set folder or display current folder name

Syntax
       folder [ +folder ] [ msg ] [ options ]

Description
       The command lets you set the current folder, or display information about it.  It can also be used to manage the folder stack.

       If  you	use  the command without a +folder argument, information about the current folder is displayed on the screen.  If you use with the
       +folder argument, the named folder is set to be the current folder.  Information about the named folder is also displayed on the screen.

       If you use with the msg argument, it will set the specified message to be current.  Information on the current folder  is  also	displayed.
       You can use both the +folder and msg arguments together in one command.

       If  you	specify  a +folder that does not exist, you are asked whether you want to create it.  This is a good way to create an empty folder
       for later use.

       The display is identical whether you set the folder or display the contents of the current folder.  The following example shows the type of
       display	that  is  produced.  The display lists the current folder, the number of messages in it, the range of the messages (low-high), and
       the current message within the folder.  It also flags extra files if they exist.
			inbox+ has   16 messages (   3-  22); cur=  15.

Options
       -all	 Displays information on all the folders in your Mail directory.  The folders are listed alphabetically, with a line  of  informa-
		 tion given for each folder.  This is identical to the display produced by the command.  See

       -fast
       -nofast	 Lists only the name of the current folder, with no additional information.  This is faster because the folders need not be read.

       -header
       -noheader Displays a header produced by the system, in addition to the information about the current file.  This header is identical to the
		 one that appears at the top of the listing produced by or by The header can be suppressed by using the -noheader option.

       -help	 Prints a list of the valid options to this command.

       -list
       -nolist	 Lists the contents of the folder-stack.  No +folder argument is allowed with this option.  The contents of the  folder-stack  are
		 listed automatically when the -pop or -push option is used.  This corresponds to the operation in the C-shell.

       -pack
       -nopack	 Re-numbers  messages  in  the	folder.   Messages  are  re-numbered sequentially, and any gaps in the numbering are removed.  The
		 default operation is -nopack, which does not change the numbering in the folder.

       -pop	 Discards the top of the folder-stack, after setting the current folder to that value.	No +folder argument is allowed	with  this
		 option.  This corresponds to the operation in the C-shell; see The -push and -pop options are mutually exclusive: the last occur-
		 rence of either one overrides any previous occurrence of the other.

       -push	 Pushes the current folder onto the folder-stack, and makes the +folder argument into the  current  folder.   If  +folder  is  not
		 given,  the  current folder and the top of the folder-stack are exchanged.  This corresponds to the operation in the C-shell; see
		 The -push switch and the -pop switch are mutually exclusive: the last occurrence of either one overrides any previous	occurrence
		 of the other.

       -recurse
       -norecurse
		 Lists	each folder recursively.  Information on the current folder is displayed, followed by information on any sub-folders which
		 it contains.

       -total
       -nototal  Displays only the total number of messages and folders in your Mail directory.  This option does not print any information  about
		 the current folder.  It can be suppressed using the -nototal option.

       The defaults for are:

	      +folder defaults to the current folder
	      msg defaults to none
	      -nofast
	      -noheader
	      -nototal
	      -nopack
	      -norecurse

Examples
       The following example shows how can be used to change the current folder to and display information on that folder.  The plus sign (+) next
       to indicates that it is now the current folder.
       % folder +test
			 test+ has    2 messages (   1-   2); cur=   2.

       The next example shows the display produced by using the -all option to
	 Folder      # of messages (  range  ); cur  msg  (other files)
	   V2.3  has	3 messages (   1-   3).
	 adrian  has   20 messages (   1-  20); cur=   2.
	  brian  has   16 messages (   1-  16).
	  chris  has   12 messages (   1-  12).
	copylog  has  242 messages (   1- 242); cur= 225.
	  inbox+ has   73 messages (   1- 127); cur= 127.
	    int  has	4 messages (   1-   4); cur=   2  (others).
	   jack  has   17 messages (   1-  17); cur=  17.

		    TOTAL= 387 messages in 8 folders.

       This display is identical to that produced by the command.  See for an explanation of this display.

       The next example shows how to use to create an empty folder:
       % folder +test
       Create folder "$HOME/Mail/test"? y
		 test+ has no messages.

       You can also use to create an empty sub-folder within an existing folder.  The following example shows how you can create a  sub-folder	in
       the folder
       % folder +test/testtwo
       Create folder "$HOME/Mail/test/testwo"? y
		 test/testtwo+ has no messages.
       See for more details of sub-folders.

Files
       The user profile.

Profile Components
       Path:		 To determine your MH directory
       Current-Folder:	 To find the default current folder
       Folder-Protect:	 To set mode when creating a new folder
       Folder-Stack:	 To determine the folder stack
       lsproc:		 Program to list the contents of a folder

See Also
       csh(1), refile(1mh), mhpath(1mh)

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