Splitting a file based on record sin another file

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Splitting the file based on two fields - Fixed length file

Hi , I am having a scenario where I need to split the file based on two field values. The file is a fixed length file. ex: AA0998703000000000000190510095350019500010005101980301 K 0998703000000000000190510095351019500020005101480 ...

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

3. Shell Programming and Scripting

Keeping record of file 2 based on a reference file 1 in awk

I have 2 input files (tab separated): file1: make_A 1990 foo bar make_B 2010 this that make_C 2004 these those file2: make_X 1970 1995 ref_1:43 ref_2:65 make_A 1970 1995 ref_1:4 ref_2:21 ref_3:18 make_A 1980 2002 ref_1:7 ref_2:7 ref_3:0 ...

4. UNIX for Dummies Questions & Answers

Extracting data from one file, based on another file (splitting)

5. Shell Programming and Scripting

Need help splitting huge single record file

I was given a data file that I need to split into multiple lines/records based on a key word. The problem is that it is 2.5GB or bigger and everything I try in perl or sed causes a Segmentation fault. Can someone give me some other ideas. The data is of the form:...

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

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

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

9. Shell Programming and Scripting

Splitting a file based on the records in another file

All, We receive a file with a large no of records (records can vary) and we have to split it into two files based on another file. e.g. File1: UHDR 2008112 "25187","00000022","00",21-APR-1991,"" ,"D",-000000519,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ...

10. Shell Programming and Scripting

splitting a record and adding a record to a file

Hi, I am new to UNIX scripting and woiuld appreicate your help... Input file contains only one (but long) record: aaaaabbbbbcccccddddd..... Desired file: NEW RECORD #new record (hardcoded) added as first record - its length is irrelevant# aaaaa bbbbb ccccc ddddd ... ... ...

LEARN ABOUT OPENSOLARIS

split

split(1T)						       Tcl Built-In Commands							 split(1T)

__________________________________________________________________________________________________________________________________________________

NAME

       split - Split a string into a proper Tcl list

SYNOPSIS

       split string ?splitChars?
_________________________________________________________________

DESCRIPTION

       Returns a list created by splitting string at each character that is in the splitChars argument.  Each element of the result list will con-
       sist of the characters from string that lie between instances of the characters in splitChars.  Empty list elements will  be  generated	if
       string contains adjacent characters in splitChars, or if the first or last character of string is in splitChars.  If splitChars is an empty
       string then each character of string becomes a separate element of the result list.  SplitChars defaults to the standard white-space  char-
       acters.

EXAMPLES

       Divide up a USENET group name into its hierarchical components:
	      split "comp.lang.tcl.announce" .
		   => comp lang tcl announce

       See how the split command splits on every character in splitChars, which can result in information loss if you are not careful:
	      split "alpha beta gamma" "temp"
		   => al {ha b} {} {a ga} {} a

       Extract the list words from a string that is not a well-formed list:
	      split "Example with {unbalanced brace character"
		   => Example with {unbalanced brace character

       Split a string into its constituent characters
	      split "Hello world" {}
		   => H e l l o { } w o r l d

PARSING RECORD-ORIENTED FILES
       Parse a Unix /etc/passwd file, which consists of one entry per line, with each line consisting of a colon-separated list of fields:
	      ## Read the file
	      set fid [open /etc/passwd]
	      set content [read $fid]
	      close $fid

	      ## Split into records on newlines
	      set records [split $content "
"]

	      ## Iterate over the records
	      foreach rec $records {

		 ## Split into fields on colons
		 set fields [split $rec ":"]

		 ## Assign fields to variables and print some out...
		 lassign $fields 
		       userName password uid grp longName homeDir shell
		 puts "$longName uses [file tail $shell] for a login shell"
	      }

SEE ALSO

       join(1T), list(1T), string(1T)

KEYWORDS

       list, split, string

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+-----------------+
       |  ATTRIBUTE TYPE    | ATTRIBUTE VALUE |
       +--------------------+-----------------+
       |Availability	    | SUNWTcl	      |
       +--------------------+-----------------+
       |Interface Stability | Uncommitted     |
       +--------------------+-----------------+
NOTES

       Source for Tcl is available on http://opensolaris.org.

Tcl																	 split(1T)

UNIX for Dummies Questions & Answers