if different branch code is available for same BIC code and one of the branch code is XXX.only one row will be stored and with branch code as XXX .rest of the rows for the BIC code will not be stored.
for example if $7 is BIC code and $8 is branch code
INPUT file are following
Code:
BI M IT056868 UNICREDI VIA LIBHIA UNCRIT2B XXX UNCR
BI M US001165 NEUBERGE LLC NEWYRK NEUBUS33 253 NEUB
HH M IND90909 SBILIFES HNI NANANN GGGGGGGG 142 UICC
HH M MNOOOO 98989089 IIC UMNKSS MOHAN844 XXX KLKL
HH M MNKKKKKK 90909090 JMV MNJKMN MOHAN844 256 LOPD
HH M MKLJHJKK KIKIKIKI JKJ NMHMNM MOHAN844 456 LOPS
here $7 is having 3 bic code with same value"MOHAN844" with diff branch code in $8 and i want only BIC code with XXX value ...and if XXX is not present in $8 then i need all record..
please Help me..
Moderator's Comments:
Use code tags, thanks.
Last edited by zaxxon; 02-18-2013 at 07:35 AM..
Reason: code tags
I am doing KSH script to remove duplicate lines in a file. Let say the file has format below.
FileA
1253-6856
3101-4011
1827-1356
1822-1157
1822-1157
1000-1410
1000-1410
1822-1231
1822-1231
3101-4011
1822-1157
1822-1231
and I want to simply it with no duplicate line as file... (5 Replies)
I have a log file "logreport" that contains several lines as seen below:
04:20:00 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but responded to ping
06:38:08 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but responded to ping
07:11:05 /usr/lib/snmp/snmpdx: Agent snmpd appeared dead but... (18 Replies)
How do we sort and remove duplicate on column 1,2 retaining the record with maximum date (in feild 3) for the file with following format.
aaa|1234|2010-12-31
aaa|1234|2010-11-10
bbb|345|2011-01-01
ccc|346|2011-02-01
bbb|345|2011-03-10
aaa|1234|2010-01-01
Required Output
... (5 Replies)
Hi I have a file in the following format. Basically the file contains tablename and their aliases:
TABLE1
TABLE1 A
TABLE2
TABLE2 B
TABLE3
TABLE4
TABLE4 C
TABLE4
Upon formatting an sql statement I am getting such output.
Problem: Whenever a tablename appears with alias, it has... (5 Replies)
I have a file a.txt having content like
deepak
ram
sham
deepram
sita
kumar
I Want to delete the first line containing "deep" ...
I tried using...
grep -i 'deep' a.txt
It gives me 2 rows...I want to delete the first one..
+ need to know the command to delete the line from... (5 Replies)
Hey guys, need some help to fix this script. I am trying to remove all the duplicate lines in this file.
I wrote the following script, but does not work. What is the problem?
The output file should only contain five lines:
Later! (5 Replies)
Here is the contents of test.txt
Dependencies Resolved
Changes in packages about to be updated:
ChangeLog for: 1:perl-Archive-Extract-0.38-131.el6_4.x86_64,
- Resolves: #915692 - CVE-2013-1667 (DoS in rehashing code)
Dependencies Resolved
Changes in packages about to be updated:
... (5 Replies)
Hi,
I have a csv file which contains some millions of lines in it.
The first line(Header) repeats at every 50000th line. I want to remove all the duplicate headers from the second occurance(should not remove the first line).
I don't want to use any pattern from the Header as I have some... (7 Replies)
Hi Gurus,
I have a file(weblog) as below
abc|xyz|123|agentcode=sample code abcdeeess,agentcode=sample code abcdeeess,agentcode=sample code abcdeeess|agentadd=abcd stereet 23343,agentadd=abcd stereet 23343
sss|wwq|999|agentcode=sample1 code wqwdeeess,gentcode=sample1 code... (4 Replies)
Discussion started by: ratheeshjulk
4 Replies
LEARN ABOUT OPENSOLARIS
shcomp
shcomp(1) User Commands shcomp(1)NAME
shcomp - compile a ksh93 shell script
SYNOPSIS
shcomp [-nv] [infile [outfile]]
shcomp -D [infile [outfile]]
DESCRIPTION
If the -D option is not specified, shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 reads and
executes with the same effect as the original script.
Aliases are processed as the script is read. Alias definitions whose value requires variable expansion will not work correctly.
OPTIONS
The following options are supported:
-D Generate a list of strings that need to be placed in a message catalog for internationalization.
--dictionary
With this option, all double quoted strings that are preceded by $ are printed, one literal per line. A literal $"foo"
prints "foo" in the output. These are the messages that need to be translated to locale specific versions for internation-
alization.
-n Display warning messages for obsolete or non-conforming constructs.
--noexec
-v Display input from infile onto standard error as it reads it.
--verbose
OPERANDS
The following operands are supported:
infile Specifies the name of the file that contains the shell script to be used as input.
If infile is omitted, the shell script is read from standard input.
outfile Specifies the name of the output file.
If outfile is omitted, both modes write their results to standard output.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
|Interface Stability |See below. |
+-----------------------------+-----------------------------+
The command-line interface and the system variables are Committed. The compiled shell code format is Private. The output of the -D option
is Volatile.
SEE ALSO ksh93(1), attributes(5)SunOS 5.11 27 Jan 2009 shcomp(1)
02-18-2013
