Sponsored Content
Top Forums Shell Programming and Scripting Split file by column value, each with header Post 302985786 by RudiC on Tuesday 15th of November 2016 08:44:58 AM
Old 11-15-2016
The output is redirected to the respective file, controlled by $5, as requested in post#1. If a new (i.e. not yet registered) $5 shows up in a line, the new file name is constructed in FN[$5], and then, all lines with the same $5 are assembled in the same file. The number of files (= different unique $5) is "unlimited" (except for system factors e.g. memory).
These 3 Users Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split large file and add header and footer to each file

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

Split large file and add header and footer to each small files

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? (7 Replies)
Discussion started by: ashish4422
7 Replies

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

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... (4 Replies)
Discussion started by: Vavad
4 Replies

5. UNIX for Dummies Questions & Answers

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

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... (1 Reply)
Discussion started by: Vavad
1 Replies

6. UNIX for Dummies Questions & Answers

Column Header in the Spool file

Hi All, I have a problem with the column heading while spooling the data from the database. Since i want the column header, therefore i am not using SET HEADING OFF, and i am getting the header, but for the longer column name, some of the character from the column name is missing. for... (7 Replies)
Discussion started by: Pramod_009
7 Replies

7. Shell Programming and Scripting

Split and add header and trailer from input file

I need to split the file based on pattern from position 34-37 while retaining the header and trailer records in each individual split file Also is it possible to output the TOM and PAT records in the same output file ? I need the output file names same as xyz_pattern_Datetimestamp.txt ... (23 Replies)
Discussion started by: techedipro
23 Replies

8. Shell Programming and Scripting

Sort and Split file with header and custom name

Hi, I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240). I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,... (5 Replies)
Discussion started by: Saanvi1
5 Replies

9. Shell Programming and Scripting

Split a file based on encountering header

I need to split a file based on headers found Input file file1 content: ADD john mickey DROP matt sam output of file F1 john mickey output of file F2 matt sam (5 Replies)
Discussion started by: Diddy
5 Replies

10. Shell Programming and Scripting

Split large xml into mutiple files and with header and footer in file

Split large xml into mutiple files and with header and footer in file tried below it splits unevenly and also i need help in adding header and footer command : csplit -s -k -f my_XML_split.xml extrfile.xml "/<Document>/" {1} sample xml <?xml version="1.0" encoding="UTF-8"?><Recipient>... (36 Replies)
Discussion started by: karthik
36 Replies
mh-mail(4)						     Kernel Interfaces Manual							mh-mail(4)

NAME
mh-mail - Message format for the MH message system DESCRIPTION
MH processes messages in a particular format. Although neither Bell nor Berkeley mailers produce message files in the format that MH prefers, MH can read message files in that format. Each user has a maildrop that initially receives all messages processed by the post command (see post(8)). The inc command reads from the maildrop and incorporates the new messages found there into the user's own +inbox folder. The maildrop con- sists of one or more messages. Messages are expected to consist of lines of text. Graphics and binary data are not handled. No data compression is accepted. All text is in ASCII 7-bit data. The general memo framework of RFC 822 is used. A message consists of a block of information in a rigid format, followed by general text with no specified format. The rigidly-formatted first part of a message is called the message header; the free-format portion is called the body. The header must always exist, but the body is optional. These parts are separated by a blank line or by a line of dashes. The following example shows the standard default MH mail header: To: cc: Subject: -------- The header is composed of one or more header items. Each header item can be viewed as a single logical line of ASCII characters. If the text of a header item extends across several real lines, the continuation lines are indicated by leading spaces or tabs. Each header item is called a component and is composed of a keyword or name, along with associated text. The keyword begins at the left margin, and is terminated by a colon (:). It cannot contain spaces or tabs, and cannot exceed 63 characters, as specified by RFC 822. The text for most formatted components, such as Date: and Message-Id:, is produced automatically. The user enters address fields such as To: and cc:, and the Subject: field. Internet addresses are assigned mailbox names and host computer specifications. The general format is local@domain, for example, MH@UCI or MH@UCI-ICSA.ARPA. A comma (,) separates multiple addresses. A missing host/domain is assumed to be the local host/domain. A blank line (or a line of dashes) signals that all following text up to the end of the file is the body of the message. No formatting is expected or enforced within the body. The following is a list of header components that are considered meaningful to MH programs: Added by post, contains the date and time of the message's entry into the transport system. Added by post, contains the address of the author or authors (there may be more than one if a Sender: field is present). Replies are typically directed to addresses in the Reply-To: or From: field. The former has precedence, if present. Added by post in the event that the message already has a From: line. This line contains the address of the actual sender. Replies are never sent to addresses in the Sender: field. Contains addresses of primary recipients. Contains addresses of secondary recipients. Contains the addresses of recipients who receive blind carbon copies of the message. The Bcc: line does not appear on the message as sent, so these recipients are not listed. Recipients in the Bcc: field receive a copy of the message with a minimal header. MH uses an encapsulation method for blind copies; see send(1). Causes post to copy the message into the specified folder for the sender, if the message was successfully given to the transport system. A unique message identifier added by post, if the -msgid flag is set. Sender's commentary. It is displayed by scan. A commentary line added by repl when replying to a message. Added by post when a message is redistributed. Added by post when a message is redistributed. New recipients for a message resent by dist. New secondary recipients for a message resent by dist. New blind carbon copy recipients for a message resent by dist. Places a copy of a message resent by dist into the sender's folder. A unique identifier of a message resent by dist. This is appended by post if the -msgid flag is set. Annota- tion added by dist when the -annotate flag is specified. Annotation added by forw when the -annotate flag is specified. Annotation added by repl when the -annotate flag is specified. Specifies the MIME version number. This header entry is used or added by MH software only when codeset conversion of mail messages is enabled and requested. For more information on codeset conversion, see the section on interna- tionalization features in mh(1). Specifies the content type, which is always TEXT/PLAIN, plus a charset value that names a coded character set (codeset). This header entry is used or added by MH software only when codeset conversion of mail messages is enabled and requested. For more information on codeset conversion, see the section on internationalization features in mh(1). FILES
Standard location of mail drop RELATED INFORMATION
Standard for the Format of ARPA Internet Text Messages (RFC 822) delim off mh-mail(4)
All times are GMT -4. The time now is 05:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy