10-21-2011
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
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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
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
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
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
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
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
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
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
refile(1) General Commands Manual refile(1)
NAME
refile - file message in other folders (only available within the message handling system, mh)
SYNOPSIS
refile [msgs] [+folder] [options]
OPTIONS
Refiles the draft message, or the current message in your +drafts folder, if you have one set up. You cannot give a msgs argument when you
use this option. Moves a file into a folder. This option takes a file from its directory and places it in the named folder, as the next
message in the folder. The file must be formatted as a legal mail message. This means that the message must have the minimum header fields
separated from the body of the message by a blank line or a line of dashes. Prints a list of the valid options to this command. Keeps a
copy of the message in the source folder. Normally, refile removes the messages from the original folder when it refiles them. The -link
option keeps a copy in the original folder, as well as filing a copy in the new folder. Preserves the number of a message in the new
folder. Normally, when a message is refiled in to another folder, it is set to the next available number in that folder. The -preserve
option keeps the number of the message the same in the new folder as it had been in the old.
You cannot have two messages with the same number in one folder, so you should use this option with care. Specifies the source
folder to take messages from. Normally, messages are refiled from the current folder into another folder. However, you can take mes-
sages from a different folder by using the -src +folder option to specify the alternative source folder.
DESCRIPTION
Use the refile command to move the specified message from the current folder to another folder. You can refile messages in more than one
folder by giving multiple folder names as arguments.
If you do not specify a message, the current message is refiled. You can refile a message other than the current message by giving its num-
ber as a msgs argument. You can also refile more than one message at a time by specifying more than one message number, or a range of mes-
sage numbers, or a message sequence. See mark(1) for more information on sequences.
The current folder remains the same unless the -src option is specified; in that case, the source folder becomes current. Normally, the
last message specified becomes the current message. However, if the -link option is used, the current message is not changed.
If the Previous-Sequence: entry is set in the file, in addition to defining the named sequences from the source folder, refile will also
define those sequences for the destination folders. See mh_profile(4) for information concerning the previous sequence.
PROFILE COMPONENTS
Path: To determine your Mail directory
Folder-Protect: To set protections when creating a new folder
rmmproc: Program to delete the message
EXAMPLES
The following example refiles messages 3 and 5 in the folder +records: % refile 3 5 +records The next example files the current message
into two folders: % refile +jones +map The next example takes message 13 in the current folder and refiles it in the +test folder. The mes-
sage remains in the current folder as well as appearing in the +test folder. % refile -link 13 +test The next example takes a message from
the folder +test when it is not the current folder, and places it in the folder +outbox: % refile 3 -src +test +outbox
FILES
The user profile.
SEE ALSO
folder(1), mark(1), mh_profile(4)
refile(1)