01-23-2009
Need help with formatting an output file
Hi guys,
I need help with formatting the output of a file. Below is the script I use to generate a file called output.xls.
DAY=`TZ=MYT+16 date '+%b'`
DAY1=`TZ=MYT+16 date '+%e'`
ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c3-7 > output1
ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c13-17 > output2
paste output1 output2 > output.xls
rm output1 output2
This is how the output.xls looks like (partial file).
AREDU 772
AREDU 773
AREDU 774
ARM05 17
AUSOP 251
AZEAC 51
AZEAF 264
AZEAF 265
AZEAF 266
AZEAF 267
BELKO 172
BGDAK 258
BGDWT 199
BGRVA 745
BRNBR 186
BRNDS 79
CYPSC 129
CYPSC 130
DZAA1 16
ESPRT 55
ESTRE 308
ESTRE 309
There are identical directory name but the file sequence differ in the above example.
And this is how I would like the output.xls file to look like.
AREDU 772, 773, 774
ARM05 17
AUSOP 251
AZEAC 51
AZEAF 264, 265, 266, 267
BELKO 172
BGDAK 258
BGDWT 199
BGRVA 745
BRNBR 186
BRNDS 79
CYPSC 129, 130
DZAA1 16
ESPRT 55
ESTRE 308, 309
Is there a way I could accomplish this. Please advice.
Thank you all for your assistance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I have a file....
File1:
Num Name ID Place ADDR City Country
1024|Name1|ID1|Street1|ADDR1|Boston|UK
1025|Name2|ID3|Street2|ADDR2|London|USA
The above file is varaiable length file. I have to insert 2 values in every record of the above file.
Output:
... (3 Replies)
Discussion started by: manneni prakash
3 Replies
2. Shell Programming and Scripting
my script is as follows
cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'`
cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'`
if
then
if
then
rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt
... (1 Reply)
Discussion started by: swkambli
1 Replies
3. Shell Programming and Scripting
Hi guys.
I'm new to Bash Programming.
I've a little problem here.
I have a text file, lets say data.txt, with the data:
John Tan:Male:20:Singapore
Mary:Female:23:Malaysia
Abdul Rahman Bin Ali:Male:30:India
(: is the delimiter)
I want to display it like this:
Name Gender Age... (6 Replies)
Discussion started by: andylbh
6 Replies
4. Shell Programming and Scripting
I have a file that list information about users and want to format the output into columns using Shell scripting. There are about 50 to 75 users. Example
current file output
fname
lname
address
hiredate
dept
fname
lname
address
hiredate
dept
Desired output
fname ... (4 Replies)
Discussion started by: daveisme
4 Replies
5. Shell Programming and Scripting
below is a CPU utilization Log for ABC server.
However for every 15 minutes it generates 3 CPU values(with interval of 2 sec).
Host CPU CPUtotal CPU% time
ABC 101.1 2 50.55 14 : 15
ABC 100.5 2 50.25 14 : 15
ABC 100.2 2 50.1 14 : 15
ABC 100.9 2 50.45 14 : 30
ABC 100.5 2 50.25 14 : 30
ABC... (5 Replies)
Discussion started by: pinga123
5 Replies
6. Shell Programming and Scripting
Hi,
I have a file like this
--------------------------
1 aaa xxx 55
--------------------------
1 aaa www 32
--------------------------
2 bbb yyy 11
--------------------------
2 bbb zzz 34
-------------------------
2 bbb ttt ... (3 Replies)
Discussion started by: tdev457
3 Replies
7. Shell Programming and Scripting
I have the output like below:
DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance
SERIAL: 68173531021
==========================================================================
Path# Adapter/Path Name State Mode Select Errors
0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies
8. Shell Programming and Scripting
Hi,
I am trying to use printf command and format certain output in a specific format as under:
While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies
9. Shell Programming and Scripting
Hi All,
Need your help in resolving the below issue.
I've a file called "data.txt" with the below lines:
TT: <tell://me/sreenivas>
<tell://me/100>
TT: <tell://me/sudheer>
<tell://me/300>
TT: <tell://me/sreenivas>
<tell://me/200>
TT: <tell://me/sudheer>
<tell://me/400>
... (3 Replies)
Discussion started by: raosr020
3 Replies
10. Shell Programming and Scripting
Below is the out put of the decrypt command.
Decrypt Command:
/usr/bin/gpg --yes --batch --output file.xml --decrypt file.xml.gpg
Output:
gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29
"XYZ <xyz@abc.com>"
gpg: encrypted with 2048-bit ELG-E key, ID ECB614CF,... (5 Replies)
Discussion started by: Ariean
5 Replies