12-17-2008
Script to extract fields
Dear all,
please see the logs shown below:
12-12 08:47:37.545 DBG AGIML SERVER[1]..............................write() (<agiml><header><responsetype>TOPUP</responsetype></header><response><auditfields/><resultcode>999</resultcode>
<account>9773575450</account><transno>1317</transno><incode>BPL</incode><resultdescription></resultdescription><inresultcode>1</inresultcode><inmtransno>229051853686229</inmtransno><flowControlCode></flowControlCode><flowControlLevel></flowControlLevel><intransno></intransno><acls/><authorities/><records/></response></agiml>)
Now i want to write a script which will extract the fields like this
TOPUP,9773575450,1317,BPL,1
these are the fields shown in the different tags.
And one thing more the fields between the tag <agiml>............</agiml>,
it is taking it a single column of log.
example less file | grep "9773575450"
will display the whole line.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i would like to extract the just name field from /etc/passwd file, and nothing else. ie grep pauline, and Pauline Fowler comes back.
cheeers
paul mc (6 Replies)
Discussion started by: mopimp
6 Replies
2. Shell Programming and Scripting
thank youuuu (0 Replies)
Discussion started by: rnallamothu
0 Replies
3. Shell Programming and Scripting
Hi
I am newbie.My requirement is:
I have start time :Wed Apr 30 3:30:45
End time :Wed Apr 30 3:35:45
which is stored in a file.
I have to extract timestamp 3:30:45 using awk. And Subtract the same
The script:
----------
#!/bin/ksh
LOG_FILE=$1
START_TIME=`head -2 $LOG_FILE... (1 Reply)
Discussion started by: usshell
1 Replies
4. Shell Programming and Scripting
Hi,
I have a tmp file like below:
<ADATA>
ANUM=900
ADESC=Saving
ATYP=0
TXREGD=0
</ADATA>
<ADATA>
ANUM=890
ADESC=Saving
ATYP=0
ABAL=9000
TXREGD=1
</ADATA>
<ADATA> (2 Replies)
Discussion started by: kunigirib
2 Replies
5. UNIX for Dummies Questions & Answers
Hi!
i want to extract from /etc/passwd file,the user and user info fileds, to a another file.I've tried this:
cut -d ':' -f1 ':' -f6 < file
but cut can be used to extract olny one field and not two.
maybe with awk is this possible? (4 Replies)
Discussion started by: strawhatluffy
4 Replies
6. Shell Programming and Scripting
Hi,
I have data like below.
SID=D6EB96CC0
HID=9C246D6
CSource=xya
Cappe=1
Versionc=3670
MAR1=STL
MARS2=STL
REQ_BUFFER_ENCODING=UTF-8
REQ_BUFFER_ORIG_ENCODING=UTF-8
RESP_BODY_ENCODING=UTF-8
CON_ID=2713
I want to select
CSource=xya (18 Replies)
Discussion started by: chetan.c
18 Replies
7. Shell Programming and Scripting
Hi,
I need to call an API (GetUsageDetails)from inside a shell script which takes an input argument acct_nbr.
The output of API will be like :
<usageAccum accumId="450" accumCaptn="PM_125" inclUnits="1410.00" inclUnitsUsed="744.00" shared="true" pooled="false" prorated="false"... (1 Reply)
Discussion started by: rkrish
1 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have below file structure and need to display hours, minutes and seconds as different fields.
Incase hour or minute field is not there it should default to zero.
*** Total elapsed time was 2 hours, 54 minutes and 40 seconds.
*** Total elapsed time was 42 minutes and 36 seconds.... (7 Replies)
Discussion started by: fristyguy
7 Replies
9. Shell Programming and Scripting
Hello
I have a log file with thousands of lines like below
Sep 21 13:02:52 lnxtst01 kernel: New TCP in: IN=eth0 OUT= MAC=00:1a:4b:50:b7:32:00:08:e3:ff:fc:04:08:00 SRC=10.184.46.4 DST=10.162.139.21 LEN=60 TOS=0x00 PREC=0x00 TTL=59 ID=52961 DF PROTO=TCP SPT=55688 DPT=22 WINDOW=5840 RES=0x00 SYN... (3 Replies)
Discussion started by: magnus29
3 Replies
10. UNIX for Beginners Questions & Answers
can anyone help me!!!! How to I parse the CSV file
file name : abc.csv (csv file) The above file containing data like
abv,sfs,,hju,',',jkk wff,fst,,rgr,',',rgr ere,edf,erg,',',rgr,rgr I have a requirement like i have to extract different field and assign them into different... (4 Replies)
Discussion started by: J.Jena
4 Replies
tar(4) Kernel Interfaces Manual tar(4)
NAME
tar - format of tar tape archive
DESCRIPTION
The header structure produced by (see tar(1)) is as follows (the array size defined by the constants is shown on the right):
All characters are represented in ASCII. There is no padding used in the header block; all fields are contiguous.
The fields magic, uname, and gname are null-terminated character strings. The fields name, linkname, and prefix are null-terminated char-
acter strings except when all characters in the array contain non-null characters, including the last character. The version field is two
bytes containing the characters (zero-zero). The typeflag contains a single character. All other fields are leading-zero-filled octal
numbers in ASCII. Each numeric field is terminated by one or more space or null characters.
The name and the prefix fields produce the pathname of the file. The hierarchical relationship of the file is retained by specifying the
pathname as a path prefix, with a slash character and filename as the suffix. If the prefix contains non-null characters, prefix, a slash
character, and name are concatenated without modification or addition of new characters to produce a new pathname. In this manner, path-
names of at most 256 characters can be supported. If a pathname does not fit in the space provided, the format-creating utility notifies
the user of the error, and no attempt is made to store any part of the file, header, or data on the medium.
SEE ALSO
tar(1)
STANDARDS CONFORMANCE
tar(4)