Shell Programming and Scripting

Hi
extending to one of my previous posted query ....
I am using

nawk -v invar1="$aa" '{print > ("ABS\_"((/\|/)?"A\_":"B\_")invar1"\_NETWORKID.txt")}' spfile.txt

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

nawk -v invar1="$aa" invar2="$bb" '{print > ("ABS\_"((/\|/)?"A\_":"B\_")invar1"\_"invar2".txt")}' spfile.txt

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

and 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

THEN

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|

Many many thanks in advance
regards
jc

Code:

... -v invar1="$aa" -v invar2="$bb" ...

as many -v as necessary

Hi
Thanks for your quick reply !!

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

regards
JC

Code:

grep ^[a-z] infile >>output1
grep ^[0-9] infile >>output2

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 :

Code:

strings spfile

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

Code:

SQL> create spfile from pfile

Try this:

Code:

awk -F"|" -v aa="xxxx" -v bb="yyyy" ' {
  fn=length($1)==4?"A":"B"
  print > "ABS_" fn "_" aa "_" bb ".txt"
}' file

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

Lol ... Ok