Split file by column value, each with header Post: 302985753

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?

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?

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

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

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

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

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

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

LEARN ABOUT OSX

mac::types

Types(3)						User Contributed Perl Documentation						  Types(3)

NAME

       Mac::Types - Macintosh Toolbox Types and conversions.

DESCRIPTION

       Access to Inside Macintosh is essential for proper use of these functions.  Explanations of terms, processes and procedures are provided
       there.  Any attempt to use these functions without guidance can cause severe errors in your machine, including corruption of data. You have
       been warned.

   Functions
       MacPack [ CONVERTERS ...] CODE, DATA ...
	   Convert a perl value into a Mac toolbox type. Predefined codes are:

	   TEXT
	       Text (an identity operation).

	   enum
	   type
	   keyw
	       A 4-byte string.

	   bool
	       A boolean.

	   shor
	       A short integer.

	   long
	       A long integer.

	   sing
	       A single precision float.

	   doub
	       A double precision float.

	   magn
	       An unsigned long.

	   qdrt
	       A QuickDraw "Rect".

	   'STR '
	       A pascal style string.

	   'STR#'
	       A string list.

	   'fss '
	       A file specification record.

	   You can pass further code mappings as hash references.

       MacUnpack [ CONVERTERS ...] CODE, DATA
	   Convert a Mac toolbox type into a perl value. Predefined codes are as for "MacPack". You can pass further code mappings as hash
	   references.

   XS Functions
       Debugger [ MSG ]
	   Break into MacsBug. Don't use this if you don't know what MacsBug is.

AUTHOR

       Written by Matthias Ulrich Neeracher <neeracher@mac.com>.  Currently maintained by Chris Nandor <pudge@pobox.com>.

perl v5.16.2							    2013-08-25								  Types(3)