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
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. UNIX for Advanced & Expert Users
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
TRUNCATE(1) User Commands TRUNCATE(1)
NAME
truncate - shrink or extend the size of a file to the specified size
SYNOPSIS
truncate OPTION... FILE...
DESCRIPTION
Shrink or extend the size of each FILE to the specified size
A FILE argument that does not exist is created.
If a FILE is larger than the specified size, the extra data is lost. If a FILE is shorter, it is extended and the extended part (hole)
reads as zero bytes.
Mandatory arguments to long options are mandatory for short options too.
-c, --no-create
do not create any files
-o, --io-blocks
treat SIZE as number of IO blocks instead of bytes
-r, --reference=RFILE
base size on RFILE
-s, --size=SIZE
set or adjust the file size by SIZE bytes
--help display this help and exit
--version
output version information and exit
The SIZE argument is an integer and optional unit (example: 10K is 10*1024). Units are K,M,G,T,P,E,Z,Y (powers of 1024) or KB,MB,... (pow-
ers of 1000).
SIZE may also be prefixed by one of the following modifying characters: '+' extend by, '-' reduce by, '<' at most, '>' at least, '/' round
down to multiple of, '%' round up to multiple of.
AUTHOR
Written by Padraig Brady.
REPORTING BUGS
GNU coreutils online help: <http://www.gnu.org/software/coreutils/>
Report truncate translation bugs to <http://translationproject.org/team/>
COPYRIGHT
Copyright (C) 2017 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
dd(1), truncate(2), ftruncate(2)
Full documentation at: <http://www.gnu.org/software/coreutils/truncate>
or available locally via: info '(coreutils) truncate invocation'
GNU coreutils 8.28 January 2018 TRUNCATE(1)