11-15-2016
@drl: I considered csplit as well, but noticed that column headers will be part of the next file, then.
This User Gave Thanks to RudiC For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello I am facing a scenario where I have a file with XML content and I am running shell script over it. But the problem is the XML is getting updated with new services. In the below scenario, my script takes values from the xml file from one service name say ABCD. Since there are multiple, it is... (8 Replies)
Discussion started by: chiru_h
8 Replies
2. Solaris
I am currently in FTP.
I want to transfer two files and need the out put in One file.
Can you help me.... (3 Replies)
Discussion started by: manish.s
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
i need to break a file into 2 files afetr matching a pattern
for ex. there is a fil, file .txt which contains
here i need to look for mat $ demon if it matches then i need to transfer the data into another file till the line in which a "d6s" comes,and i have to delete tat line... (3 Replies)
Discussion started by: manit
3 Replies
4. Shell Programming and Scripting
i had a file where lines appear to be broken when they shouldn't
eg
Line 1. kerl abc sdskd sdsjkdlsd sdsdksd \
Line 2. ksdkks sdnjs djsdjsd
i can do a shift join to combine the lines but i there are plenty of files with this issue
Line 1. kerl abc sdskd sdsjkdlsd sdsdksd ksdkks sdnjs... (6 Replies)
Discussion started by: mad_man12
6 Replies
5. UNIX for Dummies Questions & Answers
Hi,
Please help How to compare two files-
Any mismatches 2nd and 3rd column's values corresponding to 1st column.
file1
15294024|Not Allowed|null
15291398|Not Allowed|null
15303292|Dropship (standard)|N
15303291|Dropship (standard)|N
15275561|Store Only|Y
15275560|Store Only|Y... (2 Replies)
Discussion started by: Ankita Talukdar
2 Replies
6. UNIX for Dummies Questions & Answers
Hello experts, I need help writing individual files from a data matrix, with each new file being written every time there is a blank line:
From this
cat file.txt
col1 col2 col3
6661 7771 8881
6661 7771 8881
6661 7771 8881
col1 col2 col3
3451 2221 1221... (6 Replies)
Discussion started by: torchij
6 Replies
7. UNIX for Dummies Questions & Answers
Hi
Please help me to compare two files and output into a new file
file1.txt
15114933 |4001
15291649 |933502
15764675 |4316
15764678 |4316
15761974 |282501
15673104 |933505
15673577 |933505
15673098 |933505
15673096 |933505
15673092 |933505
15760705 ... (13 Replies)
Discussion started by: Ankita Talukdar
13 Replies
8. Shell Programming and Scripting
Hello,
I am coding a script to check mysql databases using bash script, I would like to check if the status of a table is not 'OK', will return the table name and do some more actions:
check.log
table1 OK
table2 Some error here
table3 ... (5 Replies)
Discussion started by: Abu Rayane
5 Replies
9. Shell Programming and Scripting
Hi,
I am new to shell script programming. I have written a ksh script to run the sql File placed in server directory and spool the output in destination directory.
Below Command:
$ORACLE_HOME/bin/sqlplus -s $ora_uid @$sqlfile_loc$testquery.sql > $opfiledirectory
It is generating the output... (6 Replies)
Discussion started by: Sumit Arora
6 Replies
10. UNIX for Beginners Questions & Answers
I am trying to consolidate multiple information files (<hostname>.Linux.nfslist) into one file so that I can import it into Excel. I can get the file contents with cat *Linux.nfslist >> nfslist.txt. I need each line prefaced with the hostname. I am unsure how to do this.
--- Post updated at... (5 Replies)
Discussion started by: Kentlee65
5 Replies
LEARN ABOUT ULTRIX
csplit
csplit(1) General Commands Manual csplit(1)
Name
csplit - context split
Syntax
csplit [ -s ] [ -k ] [ -f prefix ] file arg1 [ ...argn ]
Description
The command reads file and separates it into n+1 sections, as defined by the arguments arg1...argn. By default, the sections are placed in
xx00...xxn (n may not be greater than 99). The named file is sectioned in the following way:
00: From the start of file up to (but not including) the line referenced by arg1.
01: From the line referenced by arg1 up to the line referenced by arg2.
.
.
.
n: From the line referenced by argn to the end of file.
If the file argument is a minus (-) then standard input is used. A minus is an ASCII octal 055.
Options
-s Suppresses the printing of all character counts. If the -s option is omitted, the command prints the character counts
for each file created.
-k Leaves previously created files intact. If the -k option is omitted, automatically removes created files if an error
occurs.
-fprefix Names the created files prefix00...prefixn. The default is xx00...xxn.
The arguments (arg1...argn) to can be a combination of the following:
/rexp/[offset] A file is created for the section from the current line up to (but not including) the line containing the regular
expression rexp. The current line becomes the line containing rexp. The optional offset is plus (+) or minus
(-) the number of lines. For example, /Page/-5.
%rexp%[offset] This argument is the same as /rexp/[offset], except that no file is created for the section.
lnno A file is created from the current line up to (but not including) lnno. The current line becomes lnno.
{num} Repeat argument. This argument may follow any of the above arguments. If it follows a rexp argument, that argu-
ment is applied num more times. If it follows lnno, the file will be split every lnno lines (num times) from
that point.
Enclose all rexp type arguments that contain blanks or other characters meaningful to the Shell in the appropriate quotes. Regular expres-
sions should not contain embedded new-lines. The command does not affect the original file; it is the user's responsibility to remove it.
Examples
csplit -f cobol file /procedure division/ /par5./ /par16./
This example creates four files, cobol00...cobol03. After editing the files that created, they can be recombined as follows:
cat cobol0[0-3] > file
Note that this example overwrites the original file.
csplit -k file 100 {99}
This example splits the file every 100 lines, up to 10,000 lines. The -k option causes the created files to be retained if there are less
than 10,000 lines; however, an error message would still be printed.
csplit -k prog.c '%main(%' '/^}/+1' {20}
Assuming that follows the normal C coding convention of ending routines with a right brace (}) at the beginning of the line, this example
creates a file containing each separate C routine (up to 21) in
Diagnostics
The diagnostics are self explanatory except for the following:
arg - out of range
This message means that the given argument did not reference a line between the current position and the end of the file.
See Also
ed(1), sh(1)
csplit(1)