11-19-2010
Hi
Thanks Franklin for your reply !!!
ctsgnb -> Sorry to confuse you !
Actually here by spfile I mean one of the spool file created through one of the standalone PL/SQL block in my earlier steps of shell script
Later this spfile.txt need to be splited into 2 different files by using the nawk as discussed, for which you gave the solution.
spfile.txt containing the lines having 5th character as "|" to be moved into one file and the other lines into another file.
Brief example:-
spfile.txt is
aaa1|bbb1|ccc1
11|21|31|
12|22|32|
13|23|33|
14|24|34|
aaa2|bbb2|ccc2
31|51|71|
32|52|72|
33|53|73|
34|54|74|
aaa3|bbb3|ccc3
41|61|81|
42|62|82|
43|63|93|
44|64|94|
aaa4|bbb4|ccc4
After split
First file output should be (File ABS_A_xxxx_yyyy.txt)
aaa1|bbb1|ccc1
aaa2|bbb2|ccc2
aaa3|bbb3|ccc3
aaa4|bbb4|ccc4
Second file output should be (File ABS_B_xxxx_yyyy.txt)
11|21|31|
12|22|32|
13|23|33|
14|24|34|
31|51|71|
32|52|72|
33|53|73|
34|54|74|
41|61|81|
42|62|82|
43|63|93|
44|64|94|
I really appreciate your detailed explaination of any query posted.
Hats off !!
Regards
JC
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an input file like:
111
abcdefgh
asdfghjk
dfghjkl
222
aaaaaaa
bbbbbb
333
djfhfgjktitjhgfkg
444
djdhfjkhfjkghjkfg
hsbfjksdbhjkgherjklg
fjkhfjklsahjgh
fkrjkgnj
I want to read this input file and make separate output files with the header as numric value like "111"... (9 Replies)
Discussion started by: saltysumi
9 Replies
2. Shell Programming and Scripting
Hi
I have to write a script to split the huge file into several pieces. The file columns is | pipe delimited. The data sample is as:
6625060|1420215|07308806|N|20100120|5572477081|+0002.79|+0000.00|0004|0001|......... (3 Replies)
Discussion started by: lakteja
3 Replies
3. Shell Programming and Scripting
I have a file as:
I/P File:
Ground Car 2009
Lib 2008
Lib 2003
Ground Car 2009
Ground Car 2003
Car 2005
Car 2003
Car 2005
Sita 2900 2006
Car 2007
I have to split the file into two: - one for names and second for years.
O/p1 (Names):
Ground Car (3 Replies)
Discussion started by: karumudi7
3 Replies
4. UNIX for Advanced & Expert Users
Hi Folks,
Please help me in solving the problem.
I want to write script in order to split a file into small pieces and send it automatically through mail.
Ex. The file name is CALM*.txt . It is around 50 MB. I want to split the file into 20 MB 2-3 smaller files and send (like uuencode) it... (6 Replies)
Discussion started by: piyushbhashkar
6 Replies
5. Shell Programming and Scripting
Hi all,
I am new to scripting and I have a requirement
we have source file as
HEADER 01.10.2010 14:32:37 NAYA
TA0022
TA0000
20000001;20060612;99991231;K4;02;3
20000008;20080624;99991231;K4;02;3
20000026;19840724;99991231;KK;01;3
20000027;19840724;99991231;KK;01;3... (6 Replies)
Discussion started by: srk409
6 Replies
6. Shell Programming and Scripting
I have an input file with contents like:
MainFile.dat:
12247689|7896|77698080
16768900|hh78|78959390
12247689|7896|77698080
16768900|hh78|78959390
12247689|7896|77698080
16768900|hh78|78959390
12247689|7896|77698080
16768900|hh78|78959390
12247689|7896|77698080
16768900|hh78|78959390
... (4 Replies)
Discussion started by: rkrish
4 Replies
7. Shell Programming and Scripting
Hi ,
I am receiving a CSV file that can vary in number of rows each time.
I am supposed to split this file into 3 separate files like this:
1. create a file named 'File1.csv' that will contain first 3 rows of the input file
2. create file named 'File2.csv' that will contain last 3 rows of the... (7 Replies)
Discussion started by: kedrick
7 Replies
8. Shell Programming and Scripting
Hello,
I have one file which is in size around 20 MB , wanted to split up into four files of each size of 5 MB.
ABCD_XYZ_20130302223203.xml.
Requirement is that to write script which should do as : first three file should be of size 5 MB each, the fourth one content should be in the last... (8 Replies)
Discussion started by: ajju
8 Replies
9. Shell Programming and Scripting
Hello Shell Guru's
I have a requirement to split the source xml file into three different text file.
And i need your valuable suggestion to finish this.
Here is my source xml snippet, here i am using only one entry of <jms-system-resource>. There may be multiple entries in the source file.
... (5 Replies)
Discussion started by: Siv51427882
5 Replies
10. Shell Programming and Scripting
Hello,
I have some large text files that look like,
putrescine
Mrv1583 01041713302D
6 5 0 0 0 0 999 V2000
2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0
5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0
3.5217 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies
trcs(1) User Manuals trcs(1)
NAME
trcs - convert text files from one codeset to other
SYNOPSIS
trcs -C | -l | -h
trcs [-s] [-f input-codeset ] [-t output-codeset ] [ file ]...
DESCRIPTION
trcs is a program for translation of text files from one codeset to other. When exact translation is impossible it tries to make approxi-
mations. For example pseudographic characters are approximated by ASCII characters in codesets that have no pseudographic characters and
characters with diacritical marks are approximated by existing characters.
If the option -s or --gen-script is given trcs will generate simple script that invokes tr(1) This is useful if you want to include this in
your script or for faster conversion of many files.
If none of -C, -s, -l, -h and their equivalents is given each file will be read assuming it is coded with codeset input-codeset On standard
output it will be recoded so to use codeset output-codeset If there is no file given trcs will act as filter. Both input-codeset and out-
put-codeset are case insensitive and default to `cp1251'.
OPTIONS
-C, --copyright
Display copying conditions and warranty information.
-s, --gen-script
Generates conversion script for given input and output encodings instead to convert text files.
-l, --list
List all known codesets with their aliases.
-h, --help
Display this help and exit.
-f input-codeset, --from[=]input-codeset
Codeset of the source.
-f output-codeset, --to[=]output-codeset
Codeset of the output.
EXAMPLES
trcs -fcyrillic -t koi8-r letter.txt
Convert letter.txt from ISO-8859-5 (cyrillic) to KOI8-R and output the result on standard output.
trcs --from cp437 --to=mik --gen-script >ibm2mik
Generates script ibm2mik for converting from CP437 to MIK.
sh ibm2mik screen.txt
Convert screen.txt from CP437 to MIK. Output the result on standard output. Without parameters ibm2mik acts as filter.
AUTHOR
Anton Zinoviev <anton@lml.bas.bg>, <zinoviev@fmi.uni-sofia.bg>
SEE ALSO
tr(1)
Linux JUN 2000 trcs(1)