02-17-2010
using txr to extract information from output
am using txr command (txr 1097) on a process that generates the following output. Im trying to extract the 13th field from the highlighted string. it is delimited by '?'. The 13th field corresponds to the '0' (in bold). can you let me know how I can extract the 13 th field please?
Searching /live/midware/AL2/trace/trace.170210 for EDR=1097 any USER
1097 req 12:07:50 qid=30 pid=62 hdr=[ IVR~~11 IVR1001 02] F176!ACCNO/xxxxxxxxxxxxxx !ROLECDCNT/00000!PRDHLDRLCD/000!C.MORE/00000!LSTOCISPTY/0 !LSTPRDRLCD/0 !LSTPRODID/0 !LSTAMDEFDT/00000000!
1097 res 12:07:51 qid=23 0??0?2?163002?Channel Outlet Id invalid??0?????0???????????????????????????????????????0?????~
1097 req 12:19:35 qid=30 pid=62 hdr=[ IVR~~11 IVR1003 02] F176!ACCNO/xxxxxxxxxxxxxx !ROLECDCNT/00000!PRDHLDRLCD/000!C.MORE/00000!LSTOCISPTY/0 !LSTPRDRLCD/0 !LSTPRODID/0 !LSTAMDEFDT/00000000!
1097 res 12:19:35 qid=23 0??0?2?163002?Channel Outlet Id invalid??0?????0???????????????????????????????????????0?????~
Searched /live/midware/AL2/trace/trace.170210 for EDR 1097 any USER (31 lines)
2 requests
2 responses
thanks very much.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all, i am quite new with Perl (just 1 week of experience) and i am suppose to understand the usage of library, which i can't, anyway...
i came across this library...i think from the linux redhat redhat.linux.lib.pl, there are a couple of functions there that can be used to retrieve information... (3 Replies)
Discussion started by: mercz
3 Replies
2. Shell Programming and Scripting
Hi all,
I am working on a shell script to extract information from a file that has output from Oracle sqlplus. The problem is that the output of a single line is spread across multiple lines and i do not know as how to extract the particular filed at ones,which spans multiple lines.... (2 Replies)
Discussion started by: harris2107
2 Replies
3. Shell Programming and Scripting
am using txr command (txr 1097) on a process that generates the following output. Im trying to extract the 13th field from the highlighted string. it is delimited by '?'. The 13th field corresponds to the '0' (in bold). can you let me know how I can extract the 13 th field please?
... (1 Reply)
Discussion started by: pazman
1 Replies
4. UNIX for Dummies Questions & Answers
Hi
I need to put together a script that will search certain tables in a db and send that data to a csv file.
Basically I am importing data to a db and I want to write a script to check that all information was imported correctly.
Thank you (1 Reply)
Discussion started by: ladyAnne
1 Replies
5. Shell Programming and Scripting
Hi, i have a file like this:
<Iteration>
<Iteration_iter-num>3</Iteration_iter-num>
<Iteration_query-ID>lcl|3_0</Iteration_query-ID>
<Iteration_query-def>G383C4U01EQA0A length=197</Iteration_query-def>
<Iteration_query-len>197</Iteration_query-len>
... (9 Replies)
Discussion started by: the_simpsons
9 Replies
6. Shell Programming and Scripting
hi, i have a file A like this:
******************* No 2823 ********************
contig15205-
G383C4U02H4G80+ is in contig15205-
G383C4U02HGLXM- is in contig15205-
G383C4U01C3HIZ+ is in contig15205-
... (3 Replies)
Discussion started by: the_simpsons
3 Replies
7. Shell Programming and Scripting
Hi,
I am trying to extract a specific information from a file which contains more than 200 million records. Attached the input file for your reference.
My file contains information below
... (4 Replies)
Discussion started by: rramkrishnas
4 Replies
8. Shell Programming and Scripting
Hello!
I need help :) I have a file like this:
AA BC FG
RF TT GH
DD FF HH
(a few number of rows and three columns) and I want to put the letters of each column in a variable step by step in order to give them as input in another script. So I would like to obtain:
for the 1° loop:... (11 Replies)
Discussion started by: edekP
11 Replies
9. Shell Programming and Scripting
Gents,
If is possible please help.
I have a big file (example attached) which contends exactly same value in column, but from column 2 to 6 these values are diff. I will like to compile for all records all columns like the example attached in .csv format (output.rar ).. The last column in the... (11 Replies)
Discussion started by: jiam912
11 Replies
10. Shell Programming and Scripting
In a particular directory, there can be 1000 files like below.
filename is job901.ksh
#!/bin/ksh
cront -x << EOJ
submit file=$PRODPATH/scripts/genReport.sh maxdelay=30
&node=xnode01
tname=job901
&pfile1=/prod/mldata/data/test1.dat
... (17 Replies)
Discussion started by: vedanta
17 Replies
OD(1) FSF OD(1)
NAME
od - dump files in octal and other formats
SYNOPSIS
od [OPTION]... [FILE]...
od --traditional [FILE] [[+]OFFSET [[+]LABEL]]
DESCRIPTION
Write an unambiguous representation, octal bytes by default, of FILE to standard output. With more than one FILE argument, concatenate
them in the listed order to form the input. With no FILE, or when FILE is -, read standard input.
All arguments to long options are mandatory for short options.
-A, --address-radix=RADIX
decide how file offsets are printed
-j, --skip-bytes=BYTES
skip BYTES input bytes first
-N, --read-bytes=BYTES
limit dump to BYTES input bytes
-s, --strings[=BYTES]
output strings of at least BYTES graphic chars
-t, --format=TYPE
select output format or formats
-v, --output-duplicates
do not use * to mark line suppression
-w, --width[=BYTES]
output BYTES bytes per output line
--traditional
accept arguments in traditional form
--help display this help and exit
--version
output version information and exit
Traditional format specifications may be intermixed; they accumulate:
-a same as -t a, select named characters
-b same as -t oC, select octal bytes
-c same as -t c, select ASCII characters or backslash escapes
-d same as -t u2, select unsigned decimal shorts
-f same as -t fF, select floats
-h same as -t x2, select hexadecimal shorts
-i same as -t d2, select decimal shorts
-l same as -t d4, select decimal longs
-o same as -t o2, select octal shorts
-x same as -t x2, select hexadecimal shorts
For older syntax (second call format), OFFSET means -j OFFSET. LABEL is the pseudo-address at first byte printed, incremented when dump is
progressing. For OFFSET and LABEL, a 0x or 0X prefix indicates hexadecimal, suffixes may be . for octal and b for multiply by 512.
TYPE is made up of one or more of these specifications:
a named character
c ASCII character or backslash escape
d[SIZE]
signed decimal, SIZE bytes per integer
f[SIZE]
floating point, SIZE bytes per integer
o[SIZE]
octal, SIZE bytes per integer
u[SIZE]
unsigned decimal, SIZE bytes per integer
x[SIZE]
hexadecimal, SIZE bytes per integer
SIZE is a number. For TYPE in doux, SIZE may also be C for sizeof(char), S for sizeof(short), I for sizeof(int) or L for sizeof(long). If
TYPE is f, SIZE may also be F for sizeof(float), D for sizeof(double) or L for sizeof(long double).
RADIX is d for decimal, o for octal, x for hexadecimal or n for none. BYTES is hexadecimal with 0x or 0X prefix, it is multiplied by 512
with b suffix, by 1024 with k and by 1048576 with m. Adding a z suffix to any type adds a display of printable characters to the end of
each line of output. --string without a number implies 3. --width without a number implies 32. By default, od uses -A o -t d2 -w 16.
AUTHOR
Written by Jim Meyering.
REPORTING BUGS
Report bugs to <bug-coreutils@gnu.org>.
COPYRIGHT
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU-
LAR PURPOSE.
SEE ALSO
The full documentation for od is maintained as a Texinfo manual. If the info and od programs are properly installed at your site, the com-
mand
info od
should give you access to the complete manual.
od (coreutils) 4.5.3 February 2003 OD(1)