08-08-2008
Excel Column Headers
cat ABC.log | egrep "Error 500" >> /tmp/Logs.log
egrep "<Mango>.*<.Mango>" Logs.log | sed -e "s/^.*<Mango/<Mango/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp1.xls
egrep "<Apple>.*<.Apple>" Logs.log | sed -e "s/^.*<Apple/<Apple/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp2.xls
print Heading1, Heading 2 >> /tmp/output.xls
paste /tmp/temp1.xls /tmp/temp2.xls > /tmp/output.xls
Output:
Heading 1 Heading2
Mango1 Apple1
Mango2 Apple2
.
.
.
.
So on...
But when iam executing this query, The heading 1 and Heading 2 is like
"Heading1 Heading 2" in the first cell of the excel. I want them to be in different columns as column headers.
You help will be appreciated....
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file in unix with a layout like this
Column 1 - 1-12
Column 2 - 13-39
Column 3 - 40-58
Column 4 - 59-85
Column 5 - 86-120
Columbn 6 - 121-131
The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each... (30 Replies)
Discussion started by: DerangedNick
30 Replies
2. UNIX for Dummies Questions & Answers
Hi All,
I am new to UNIX can you please help me to sort a file with different columns
my file looks like this
$ cat gaut.txt
UID PID PPID PGID SID C STIME TTY TIME CMD
liveuser 3008 2892 3008 3008 0 11:58 ? 00:00:00 gnome-session
liveuser 3019 1 ... (8 Replies)
Discussion started by: cgk1983
8 Replies
3. Windows & DOS: Issues & Discussions
Hi
I have some data in my Excel File.However all the data is in one single column.I want to split it into two columns.
Current Data:
1,Hi Everyone,I am
7,New To Dos,And
17,VB Script,i could
110,have tried this thing
1800,in UNIX
Desired Output
CELL1|CELL 2
1 |Hi... (3 Replies)
Discussion started by: dashing201
3 Replies
4. Shell Programming and Scripting
Hi ,
Pls help on this.
Input file:
NAME1 BSC1
TEXT ID 1
MAINSFAIL
TEXT ID 2
DGON
TEXT ID 3
lOADONDG
NAME2 BSC2
TEXT ID 1
DGON
TEXT ID 3
lOADONG (1 Reply)
Discussion started by: bha148
1 Replies
5. Shell Programming and Scripting
Hi All,
I'm looking for a script which can transpose field names from column headers to values in one column.
for example, the input is:
IDa;IDb;IDc;PARAM1;PARAM2;PARAM3;
a;b;c;p1val;p2val;p3val;
d;e;f;p4val;p5val;p6val;
g;h;i;p7val;p8val;p9val;
into the output like this:
... (6 Replies)
Discussion started by: popesk
6 Replies
6. Shell Programming and Scripting
Hello Everyone!
I am new on this forum and this is my first post. I wish to apologize for my, not canonical, English.
I would like to solve this problem but I have no clue of how do it!I will be grateful if someone could help me!
I have a table like this:
gene TF1 TF2 TF3 TF4
gene1 1 2 3 4... (5 Replies)
Discussion started by: giuliangiuseppe
5 Replies
7. Shell Programming and Scripting
hello gurus,
Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help.
To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies
8. Shell Programming and Scripting
Hello,
I am processing a tab delimited text file and need to grab all of the column headers in an array.
The input looks like,
num Name PCA_A1 PCA_A2 PCA_A3
0 compound_00 -3.5054 -1.1207 -2.4372
1 compound_01 -2.2641 0.4287 ... (5 Replies)
Discussion started by: LMHmedchem
5 Replies
9. UNIX for Beginners Questions & Answers
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
10. UNIX for Beginners Questions & Answers
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
pppoesd(1M) pppoesd(1M)
NAME
pppoesd - PPPoE (Point-to-Point Protocol over Ethernet) server daemon
SYNOPSIS
config-file] debug-level] log-file]
DESCRIPTION
performs the server side discovery phase functionalities of PPPoE as mentioned in RFC 2516. The daemon responds to PADI and PADR packets
from clients if it can offer services desired by the client. generates a unique session-id for every client that it services. It then
forks a daemon which performs the session phase functionalities of PPPoE as mentioned in RFC 2516.
Options
supports the following command-line options:
Specifies the configuration file with absolute path
to be used by The default configuration file is
Specifies the debug level at which logging has to be
enabled. The three debug levels are:
Logs all error messages.
To log these messages, type on the command line.
Logs all warning messages.
To log these messages, type on the command line.
Logs function level debug messages.
To log these messages, type on the command line.
Specifies the log-file with absolute path to which
logs messages. The default log file is
EXAMPLES
An example usage of is as follows:
WARNINGS
Note that, you cannot run without the file. See pppoesd.conf(4) for more information.
AUTHOR
was developed by Hewlett-Packard.
FILES
PPPoE client
PPPoE relay
PPPoE server configuration file
PPP daemon
SEE ALSO
pppd(1), pppoec(1), pppoerd(1M), pppoesd.conf(4).
pppoesd(1M)