10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 Replies
2. Shell Programming and Scripting
Hi,
i wan't to pass a shellscript variable to a sql file.
a.sql
select $field from dual;
the way i am calling this is through sqlplus
field_name="sysdate"
sqlplus -s username/password@hostname:port/servicename <<EOF
@a.sql $field_name
EOF (4 Replies)
Discussion started by: reignangel2003
4 Replies
3. Shell Programming and Scripting
Hi All ,
I have a file as below .
A "1"
B "2"
C "3"
D "4"
E "5"
F "6"
A "11"
B "21"
C "31"
D "41"
E "51"
F "61"
And the output should be like
A B C D E F
1 2 3 4 5 6
11 21 31 41 51 (8 Replies)
Discussion started by: saj
8 Replies
4. UNIX for Dummies Questions & Answers
Hi to all,
I have a file with a list of values:
v1,v2,v3....,v9
need file in this format:
Name1: v1
Name2: v2
Name3: v3
...
Name9: v9
Please help me out. (2 Replies)
Discussion started by: mozi
2 Replies
5. Shell Programming and Scripting
Plese help me on this below
I have to do below 2 things in a single shell script
1) I have to search one word(eg : red) from the below sample file.
2) Then if I am getting word in the 3rd line (red) then I need to print the above 2 lines and below 2 lines from thekeyword
For Example:... (5 Replies)
Discussion started by: Maanjesh
5 Replies
6. Shell Programming and Scripting
Hi All,
need your help in renaming the file ? Please read the below data carefully. Its may b simple for you :-) just information is too long
Eg-home/user01/exercise contains
abc.log, ppp.log ,shd.log
want to rename this file with timestamp using shellscript
for this i... (8 Replies)
Discussion started by: aish11
8 Replies
7. Shell Programming and Scripting
Hi All,
I am trying to pivot the contents in a file.
Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A
B
C
... (3 Replies)
Discussion started by: new_ds_man
3 Replies
8. Shell Programming and Scripting
Hi,
I have a list of files that I want to check to see if they exist and then count how many of these files exist, I also want to do the same for the files that arent found.
I have done this by creating temp files see below but want ot do this using variables instead:
for FILE in... (7 Replies)
Discussion started by: tonydsam
7 Replies
9. Shell Programming and Scripting
Hi experts.
I got a file (500mb max) and need to pivot it (loading into ORCL) and change BLANK delimiter to PIPE |.
Sometimes there are multipel BLANKS (as a particular value may be BLANK, or simply two BLANKS instead of one BLANK).
thanks for your input!
Cheers,
Layout... (3 Replies)
Discussion started by: thomasr
3 Replies
10. Shell Programming and Scripting
I have a file in this format.
P1 P2 P3.........................
A001 v11 v21 v31......................
A002 v12 v22 v32............................
A003 v13 v23 v33..........................
A004 v14 v24 v34..............................
.
.
.
A00n... (2 Replies)
Discussion started by: vskr72
2 Replies