Shell Programming and Scripting

Hello

What command can i use to split a tab delimited txt file into two files base on the occurrence of a string

my file name is EDIT.txt

The content of file is below

Code:

XX 1234 PROCEDURES
XY 1634 PROCEDURES
XM 1245 CODES
XZ 1256 CODES

It has more than a million record
If there is PROCEDURES in a row i want to output to PROCEDURES.txt file else CODES.txt file

how would i use a AWK or SPLIT command?

Thanks for your help

Using awk:

Code:

awk '/PROCEDURES/ { print > "PROCEDURES.TXT"; next} { print > "CODES.TXT" }' infile

Hi madrazzii,
Check this out:

Code:

awk '{if($0~/PROCEDURES/) print >"PROCEDURES.TXT" ; if ($0~/CODES/) print >"CODES.txt" }' EDIT.txt

Thank you both.

I was using to separate commands to do this

Code:

sed '/procedures/d' Edit.TXT > codes.txt

grep "procedures" > Procedures.txt

But will use the awl and now

Thanks

J

To stick with the two command approach, you would be better with:-

Code:

grep "procedures" > procedures.txt
grep -v "procedures" > codes.txt

Robin

another question i had...i have a file without a file extension but can be opened in notepad. The file is 300 mb in size. it basically has multiple data sets in one file and i want to extract each of the data sets into a txt file. The remarks to identify each data set in the file are T0, P1, P2, P3, P4, P5, P6 and T9 that appear at the END of each record in the file and i want this file to be split into 8 different files where file 1 will have only records with T0 and file 2 with P1 and so on. There might be T0, P1 etc remarks in the middle of the line but the criteria to extract should be that these remarks are at the end of the row/line/record in the source file. source file name is RAW. Is there GREP command or any other command where I could use a IF then ELSE or a CASE statement

Code:

awk '{print > $3".txt"}' EDIT.txt

Code:

awk '{print > $NF".txt"}' RAW