12-07-2008
I tried pipe to awk -F\| '{print $1|$2|$8}'. The result is NOT <JOB|NAME=XXXXXX|</JOB.
The initial sed output shows like this which is OK and I can import into excel:
<JOB|APPLICATION="ABCD"|APR="1"|AUG="1"|AUTHOR="REGAL"|...|</JOB|
I am now trying to get the following output whereby only the 2nd field "ABCD", "1", "1", "REGAL" ..etc is the output
<JOB|"ABCD"|"1"|"1"|"REGAL"|...|<JOB|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Friends,
I have a log file as below
siteid = HYD
spc = 100
rset = RS_D_M
siteid = DEL
spc = 200
rset = RS_K_L
siteid = DEL2
spc = 210
rset = RS_D_M
Now I need a output like column wise as below.
siteid SPC rset
HYD 100 RS_D_M (2 Replies)
Discussion started by: suresh3566
2 Replies
2. Shell Programming and Scripting
hi,
Apologies if this has been covered.
I have requirement where i have to convert a single column into multiple column.
My data will be like this -
2
3
4
5
6
Output required -
2 3 4 5 6 (1 Reply)
Discussion started by: Nishithinfy
1 Replies
3. Shell Programming and Scripting
I'm working on a different stage of a project that someone helped me address elsewhere in these threads.
The .docs I'm cycling through look roughly like this:
1 of 26 DOCUMENTS
Copyright 2010 The Age Company Limited
All Rights Reserved
The Age (Melbourne, Australia)
November 27, 2010... (9 Replies)
Discussion started by: spindoctor
9 Replies
4. Shell Programming and Scripting
hi,
i have the file as below:
abc
def
ghi
jkl
i want the output as
abc,def,ghi,jki
please reply,
Thanks (4 Replies)
Discussion started by: namitai
4 Replies
5. Shell Programming and Scripting
Hi All
I want to have a Perl script which convert columns to rows.
The Perl should should read the data from input file.
Suppose the input file is
7215484
date to date
173.3
A
1.50
2.23
8.45
10.14
2.00
4.50
2.50
31.32
7216154
month to month (3 Replies)
Discussion started by: parthmittal2007
3 Replies
6. Shell Programming and Scripting
Need help to convert the following data
Account name: admin
Role: admin
Description: Administrator
Enabled: Yes
to
Account Name Role Description Enabled
admin admin Administrator Yes
Perl or AWK?
Thanks
San (9 Replies)
Discussion started by: sanguy
9 Replies
7. Shell Programming and Scripting
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Discussion started by: sai_2507
3 Replies
8. Shell Programming and Scripting
Hi
I have a file having the values like below
----------------------------
.set A
col1=”ABC”
col2=34
col3=”DEF”
col4=”LMN”
col5=25
.set A
.set B
col1=55
col3=”XYZ”
col4=”PQR”
col5=66
.set B
.set C
col2=”NNN” (1 Reply)
Discussion started by: Suneel Mekala
1 Replies
9. UNIX for Beginners Questions & Answers
B010215861628
MA
01020
CARRIER
B010215861695
MA
01020
CARRIER
B010215861709
MA
01020
CARRIER
My output is in the above format
I want the output to be: (4 Replies)
Discussion started by: Teegela Prathyu
4 Replies
10. Shell Programming and Scripting
Hello
I have a large database with the following structure:
Headword=Gloss1;Gloss2;Gloss3
The Glosses are separated by a ;
What I need is to reduce the multiple glosses on each row to columns
Headword=Gloss1
Headword=Gloss2
Headword=Gloss3
I had written the following script in awk... (5 Replies)
Discussion started by: gimley
5 Replies
PIPE(2) System Calls Manual PIPE(2)
NAME
pipe - create an interprocess channel
SYNOPSIS
#include <u.h>
#include <libc.h>
int pipe(int fd[2])
DESCRIPTION
Pipe creates a buffered channel for interprocess I/O communication. Two file descriptors are returned in fd. Data written to fd[1] is
available for reading from fd[0] and data written to fd[0] is available for reading from fd[1].
After the pipe has been established, cooperating processes created by subsequent fork(2) calls may pass data through the pipe with read and
write calls. The bytes placed on a pipe by one write are contiguous even if many processes are writing. Write boundaries are preserved:
each read terminates when the read buffer is full or after reading the last byte of a write, whichever comes first.
The number of bytes available to a read(2) is reported in the Length field returned by fstat or dirfstat on a pipe (see stat(2)).
When all the data has been read from a pipe and the writer has closed the pipe or exited,
read(2) will return 0 bytes. Writes to a pipe with no reader will generate a note sys: write on closed pipe.
SOURCE
/sys/src/libc/9syscall
SEE ALSO
intro(2), read(2), pipe(3)
DIAGNOSTICS
Sets errstr.
BUGS
If a read or a write of a pipe is interrupted, some unknown number of bytes may have been transferred.
When a read from a pipe returns 0 bytes, it usually means end of file but is indistinguishable from reading the result of an explicit write
of zero bytes.
PIPE(2)