10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am new at using shell scripting. So I have a question for the more experienced Linux users. I would like to perform some kind of pivot on a file.
Example Input file
COL1,"2001-01-01","2001-03-01","2001-03-24"
A1,22,,44
B1,56,78,12
C2,5,,
I would like to have to following output... (2 Replies)
Discussion started by: shanlinux
2 Replies
2. 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
3. Shell Programming and Scripting
Hi one of the output of the command is as below
# sed -n "/CCM-ResourceHealthCheck:/,/---------/{/CCM-ResourceHealthCheck:/d;/---------/d;p;}" Automation.OutputZ$zoneCounter | sed 's/$/<br>/'
Resource List : <br>
*************************** 1. row ***************************<br>
... (2 Replies)
Discussion started by: vivek d r
2 Replies
4. 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
5. Shell Programming and Scripting
Hi,
I am facing issue while reading data from a file in UNIX. my requirement is to compare two files and for the text pattern matching in the 1st file, replace the contents in second file by the contents of first file from start to the end and write the contents to thrid file.
i am able to... (2 Replies)
Discussion started by: seeki
2 Replies
6. 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
7. Shell Programming and Scripting
Hi,
I want to delete the contents of a file which are matching with contents of other file in shell scripting.
Ex.
file1
sheel,sumit,1,2,3,4,5,6,7,8
sumit,rana,2,3,4,5,6,7,8,9
grade,pass,2,3,4,5,6,232,1,1
name,sur,33,1,4,12,3,5,6,8
sheel,pass,2,3,4,5,6,232,1,1
File2... (3 Replies)
Discussion started by: ranasheel2000
3 Replies
8. UNIX for Dummies Questions & Answers
Give shell script....which takes two file names as input and compares the contents, is both are same delete second file's contents.....
I try with "diff"...... but confusion how to use "diff" with if ---else
Thanking you (5 Replies)
Discussion started by: krishnampkkm
5 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