to get 2 different files based on split condition i.e. "|"
Similar to invar1 variable in nawk I also need one more variable like invar2 to be passed into nawk. This I want to use in the place of NETWORKID
i.e. somthing similar to
Above syntax is obviously wrong, I just like to know is there a way I can pass two different variables in nawk as above or other alternate way
- - - -
Also can I use Substring in nawk, because I need to find the '|' character in certain position in every line
i.e. I need to pick only those lines whose fifth character is '|' and then put that entire line in first file or else in second file
Eg:-
if
aa=xxxx
bb=yyyyy
Any clue on my second point i.e. using substring to find the fifth position character as "|" and then placing that entire line in first file
or else in second file
By the way, you should NOT manage spfile manually (should be managed using SQL statements) you should manage the initSID.ora !
you might only use spfile to see what is in it :
but you should NOT modify it manually
(It should be regenerated from the initSID.ora)
What you should do before modif is :
1) keep a copie of the spfile and the initSID.ora before any modif
2) shutdown the database
3) rename/move the spfile (to *.old or whatever)
4) update your initSID.ora (set up new parameters...)
5) start your database (so it will take into account the initSID.ora)
6) generate the new spfile from your initSID.ora
to get 2 different files based on split condition i.e. "|"
Similar to invar1 variable in nawk I also need one more variable like invar2 to be passed into nawk. This I want to use in the place of NETWORKID
i.e. somthing similar to
Above syntax is obviously wrong, I just like to know is there a way I can pass two different variables in nawk as above or other alternate way
- - - -
Also can I use Substring in nawk, because I need to find the '|' character in certain position in every line
i.e. I need to pick only those lines whose fifth character is '|' and then put that entire line in first file or else in second file
Eg:-
if
aa=xxxx
bb=yyyyy
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)
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)
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)
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)
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)
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)
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)
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)