Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Splitting a file based on first 8 chars
Top Forums UNIX for Dummies Questions & Answers Splitting a file based on first 8 chars Post 302399666 by paruthiveeran on Monday 1st of March 2010 07:16:02 AM
Old 03-01-2010
Splitting a file based on first 8 chars
I have an input file of this format
<Date><other data>

For example,
Code:
20081213aaaaaaaaa
20081213bbbbbbbbb
20081220ccccccccc
20081220ddddddddd
20081220eeeeeeeee
20081227ffffffffffffff

The first 8 chars are date in YYYYMMDD formT. I need to split this file into n files where n is the distinct number of dates in the input file and each output file should have the respective records based on the date.

In the above example, the file should split as

Output_file_20081213
Code:
20081213aaaaaaaaa
20081213bbbbbbbbb

Output_file_20081220
Code:
20081220ccccccccc
20081220ddddddddd
20081220eeeeeeeee

Output_file_20081227
Code:
20081227ffffffffffffff

Can anyone suggest a solution? The file is very huge. So, I do not wish to just read it multiple times and pass it through an if and redirect the output.

I am looking for something efficient with a single read and multiple redirects.
Last edited by zaxxon; 03-01-2010 at 08:22 AM.. Reason: use code tags please, ty
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting a file based on some condition and naming them

I have a file given below. I want to split the file where ever I came across ***(instead you can put ### symbols in the file) . Also I need to name the file by extracting the report name from the first line which is in bold(eg:RPT507A) concatinated with DD(day on which the file runs). Can someone... (1 Reply)
Discussion started by: srivsn
1 Replies

2. Shell Programming and Scripting

splitting files based on text in the file

I need to split a file based on certain context inside the file. Is there a unix command that can do this? I have looked into split and csplit but it does not seem like those would work because I need to split this file based on certain text. The file has multiple records and I need to split this... (1 Reply)
Discussion started by: matrix1067
1 Replies

3. Shell Programming and Scripting

Splitting the file based on logic

Hello I have a requirement where i need to split the Input fixed width file which contains multiple invoices into multiple files with 2 invoices per file. Each invoice can be identified by its first line's second character which is "H" and sixth character is " " space and the invoice would... (10 Replies)
Discussion started by: dsdev_123
10 Replies

4. Shell Programming and Scripting

Splitting a file based on two patterns

Hi there, I've an input file as follows: *START 1001 a1 1002 a2 1003 a3 1004 a4 *END *START 1001 b1 1002 b2 1004 b4 *END *START 1001 c1 1004 c4 *END (6 Replies)
Discussion started by: kbirde
6 Replies

5. Shell Programming and Scripting

Splitting a file based on context.

I have file as shown below. Would like to split the file based on the context of data. Like, split the content between "---- XXX Info ----" and " ---- YYY Info ----" to a file. When I try using below command, 2nd file contains all the info starting after first "---- YYYY Info ----" instance.... (8 Replies)
Discussion started by: webkid
8 Replies

6. Shell Programming and Scripting

Splitting file based on column values

Hi all, I have a file (say file.txt) which contains comma-separated rows. Each row has seven columns. Only column 4 or 5 (not both) can have empty values like "" in each line. Sample lines So, now i want all the rows that have column 4 as "" go in file1.txt and all the rows that have column... (8 Replies)
Discussion started by: jakSun8
8 Replies

7. Shell Programming and Scripting

Splitting file based on line numbers

Hello friends, Is there any way to split file from n to n+6 into 1 file and (n+7) to (n+16) into other file etc. f.e I have source pipe delimated file with 20 lines and i need to split 1-6 in file1 and 7-16 in file2 and 17-20 in file 3 I need to split into fixed number of file like 4 files... (2 Replies)
Discussion started by: Rizzu155
2 Replies

8. Shell Programming and Scripting

AWK splitting a string of equal parts of 500 chars

Hi , can someone help me how to make an AWK code for splitting a string of equal parts of 500 chars in while loop? Thank you! (4 Replies)
Discussion started by: sanantonio7777
4 Replies

9. Shell Programming and Scripting

Splitting a file based on line number

Hi I have a file with over a million lines (rows) and I want to split everything from 500,000 to a million into another file (to make the file smaller). Is there a simple command for this? Thank you Phil (4 Replies)
Discussion started by: phil_heath
4 Replies

10. UNIX for Beginners Questions & Answers

Splitting a file based on a pattern

Hi All, I am having a problem. I tried to extract the chunk of data and tried to fix I am not able to. Any help please Basically I need to remove the for , values after K, this is how it is now A,, B, C,C, D,D, 12/04/10,12/04/10, K,1,1,1,1,0,3.0, K,1,1,1,2,0,4.0,... (2 Replies)
Discussion started by: arunkumar_mca
2 Replies

LEARN ABOUT HPUX

cfsetispeed

cfspeed(3C)															       cfspeed(3C)

NAME

       cfgetospeed(), cfsetospeed(), cfgetispeed(), cfsetispeed() - tty baud rate functions

SYNOPSIS

DESCRIPTION

       These  functions set and get the input and output speed codes in the termios structure referenced by termios_p.	The termios structure con-
       tains these speed codes representing input and output baud rates as well as other terminal related parameters.  Setting the parameters on a
       terminal file does not become effective until is successfully called.

	      returns the output speed code from the
				  termios structure referenced by termios_p.

	      sets the output speed code in the
				  termios  structure  referenced by termios_p to speed.  The speed code for a baud rate of zero, is used to termi-
				  nate the connection.	If is specified, the modem control lines are no longer asserted,  which  normally  discon-
				  nects the line.

	      returns the input speed code from the
				  termios structure referenced by termios_p.

	      sets the input speed code in the
				  termios structure referenced by termios_p to speed.

RETURN VALUE

       returns the output speed code from the termios structure referenced by termios_p.

       returns the input speed code from the termios structure referenced by termios_p.

       and return zero upon successful completion.  Otherwise, they return -1 and set to indicate the error.

ERRORS

       and fail when the following condition is encountered:

	      [EINVAL]	     The value of speed is outside the range of possible speed codes as specified in

WARNINGS

       and can be used to set speed codes in the termios structure that are not supported by the terminal hardware.

SEE ALSO

       tcattribute(3C), thread_safety(5), termio(7).

STANDARDS CONFORMANCE

																       cfspeed(3C)
All times are GMT -4. The time now is 03:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy