Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: sort out the required data
Top Forums UNIX for Advanced & Expert Users sort out the required data Post 302308661 by imas on Monday 20th of April 2009 02:19:46 AM
Old 04-20-2009
sort out the required data
Hi All,

I have a file 1.txt which has the duplicate dns entries as shown:

Name: 000f9fbc6738.net.in|Addresses: 10.241.66.169, 10.84.2.222,212.241.66.170
Name: 001371e8ed3e.net.in|Addresses: 10.241.65.153, 10.84.1.101
Name: 00e06f5bd42a.net.in|Addresses: 10.72.19.218, 172.18.72.250

**
**

Now I have another file 2.txt which shows the current active dns IP entry as shown:

000f9fbc6738|10.84.2.222|27|
001371e8ed3e|10.84.1.101|27|
00e06f5bd42a|10.72.19.218|27|

**
**

Note: here |27| means it is an active IP with respect to that mac.


Now i would like to sort this data i.e., I want the macaddress and IP which is inactive by comparing 1.txt and 2.txt file and the final output should look like the one as shown below:

Name: 000f9fbc6738.net.in|Addresses: 10.241.66.169,212.241.66.170
Name: 001371e8ed3e.net.in|Addresses: 10.241.65.153
Name: 00e06f5bd42a.net.in|Addresses: 172.18.72.250

**
**

Your suggestion/help is greatly appreciated.

Thanks
imas.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep required data from two columns

hello, I have output from a command and I need to filter some info out of that. I tried awk command but I can not grep what I am looking for: Following is the output and I need to capture "disabled" for each volume from first column and report: # vol status Volume State ... (2 Replies)
Discussion started by: za_7565
2 Replies

2. UNIX and Linux Applications

Get the data in my required form using gawk

i had the data in the following form: Branch : 3379 As On : 31-JAN-2009 Page : 1 User Id : OPER1 Date & Time : 01-FEB-2009 04:02:37 ... (2 Replies)
Discussion started by: KANNI786
2 Replies

3. Shell Programming and Scripting

[Solved] Messaging data into required report

Hello to all; hope someone can assist me in getting the required output that my manager is expecting. I have been able to generate this code which does the comparison of the files and creates the file called diff_fuss_file.txt $ vi fussrpt.pl #!/usr/bin/perl #cd /tmp #rm output.txt ... (2 Replies)
Discussion started by: gvolpini
2 Replies

4. Shell Programming and Scripting

Perl script required for processing the data

I have following result.log file (always has 2 lines) which I need to process, cat result.log name.cmd.method,"result","abc","xyz"; name="hello,mine.12345,"&"tree"&" xyz "&" tree "&" xyz", data="way,"&" 1"&"rate-me"&"1"&"rate-me",str="",ret=""; now I need to extract the strings/data as... (4 Replies)
Discussion started by: perlDiva
4 Replies

5. Shell Programming and Scripting

Want to sort a file using awk & sed to get required output

Hi All, Need Suggestion, Want to sort a file using awk & sed to get required, output as below, such that each LUN shows correct WWPN and FA port Numbers correctly: Required output: 01FB 10000000c97843a2 8C 0 01FB 10000000c96fb279 9C 0 22AF 10000000c97843a2 8C 0 22AF 10000000c975adbd ... (10 Replies)
Discussion started by: aix_admin_007
10 Replies

6. UNIX for Advanced & Expert Users

Alternative to sort -ur +1 required

I've got scripts trawling the network and dumping parsed text into files with an Epoch timestamp in column 1. I append the old data to the new data then just want to keep the top entry if there is an identical duplicate below (column 1 needs to be ignored). sort -ur +1 works a treat on a Solaris... (16 Replies)
Discussion started by: Mike Smith
16 Replies

7. Shell Programming and Scripting

Need to cut a some required data from file

Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: ORA-00942: table or view does not exist I have some thing like above in the file.. Upto this portion Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: the length can be vary .. Can some one help me in taking this portion alone ORA-00942:... (7 Replies)
Discussion started by: saj
7 Replies

8. Shell Programming and Scripting

Help Need to fetch the required data

Hi Guys, Am in need of your help one more time on my real data. I have a file which contains more than thousand lines of data Live data shown for 4 iterations. We have more than thousand lines of data:- -------------------------------------------------------------------------- ... (4 Replies)
Discussion started by: rocky2013
4 Replies

9. Shell Programming and Scripting

How to Modify a file content in UNIX and sort for only required fields ?

I have the below contents in a file after making the below curl call curl ... | grep -E "state|Rno" | paste -sd',\n' | grep "Disconnected" > test "state" : "Disconnected",, "Rno" : "5554f1d2" "state" : "Disconnected",, "Rno" : "10587563" "state" : "Disconnected",, "Rno" :... (2 Replies)
Discussion started by: Vaibhav H
2 Replies

10. Shell Programming and Scripting

Fetching the required data out of a tabular form

Hello Gurus, I am trying to fetch a required number of lines from an output of a command which is in tabular form. Below is the command for reference along with how the result is being shown on UNIX shell. /usr/openv/volmgr/bin/vmquery -b -p 5 The result of the above command is as... (6 Replies)
Discussion started by: Ali Sarwar
6 Replies

LEARN ABOUT OPENSOLARIS

iconv_pc_cyr

iconv_pc_cyr(5)                                         Standards, Environments, and Macros                                        iconv_pc_cyr(5)

NAME

       iconv_pc_cyr - code set conversion tables for Alternative PC Cyrillic

DESCRIPTION

       The following code set conversions are supported:

       +---------------------------------------------------------------------+
       |                   Code Set Conversions Supported                    |
       +--------------+--------+--------------+--------+---------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |    Target Output    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |ISO 8859-5    |iso5    | ISO 8859-5 Cyrillic |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |KOI8-R        |koi8    | KOI8-R              |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |MS 1251       |win5    | Windows Cyrillic    |
       +--------------+--------+--------------+--------+---------------------+
       |PC Cyrillic   |alt     |Mac Cyrillic  |mac     | Macintosh Cyrillic  |
       +--------------+--------+--------------+--------+---------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   PC Cyrillic to ISO 8859-5
       For the conversion of PC Cyrillic to ISO 8859-5, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | PC Cyrillic   |  ISO 8859-5    | PC Cyrillic    |  ISO 8859-5   |
       |24             | 4              |231             |311            |
       |200            | 260            |232             |312            |
       |201            | 261            |233             |313            |
       |202            | 262            |234             |314            |
       |203            | 263            |235             |315            |
       |204            | 264            |236             |316            |
       |205            | 265            |237             |317            |
       |206            | 266            |240             |320            |
       |207            | 267            |241             |321            |
       |210            | 270            |242             |322            |
       |211            | 271            |243             |323            |
       |212            | 272            |244             |324            |
       |213            | 273            |245             |325            |
       |214            | 274            |246             |326            |
       |215            | 275            |247             |327            |
       |216            | 276            |250             |330            |
       |217            | 277            |251             |331            |
       |220            | 300            |252             |332            |
       |221            | 301            |253             |333            |
       |222            | 302            |254             |334            |
       |223            | 303            |255             |335            |
       |224            | 304            |256             |336            |
       |225            | 305            |257             |337            |
       |226            | 306            |260-337         |255            |
       |227            | 307            |360             |241            |
       |230            | 310            |362-376         |255            |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to KOI8-R
       For the conversion of PC Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | PC Cyrillic   |    KOI8-R      | PC Cyrillic    |    KOI8-R     |
       |24             | 4              |242             |327            |
       |200            | 341            |243             |307            |
       |201            | 342            |244             |304            |
       |202            | 367            |245             |305            |
       |203            | 347            |246             |326            |
       |204            | 344            |247             |332            |
       |205            | 345            |250             |311            |
       |206            | 366            |251             |312            |
       |207            | 372            |252             |313            |
       |210            | 351            |253             |314            |
       |211            | 352            |254             |315            |
       |212            | 353            |255             |316            |
       |213            | 354            |256             |317            |
       |214            | 355            |257             |320            |
       |215            | 356            |260-337         |255            |
       |216            | 357            |340             |322            |
       |217            | 360            |341             |323            |
       |220            | 362            |342             |324            |
       |221            | 363            |343             |325            |
       |222            | 364            |344             |306            |
       |223            | 365            |345             |310            |
       |224            | 346            |346             |303            |
       |225            | 350            |347             |336            |
       |226            | 343            |350             |333            |
       |227            | 376            |351             |335            |
       |230            | 373            |352             |337            |
       |231            | 375            |353             |331            |
       |232            | 377            |354             |330            |
       |233            | 371            |355             |334            |
       |234            | 370            |356             |300            |
       |235            | 374            |357             |321            |
       |236            | 340            |360             |263            |
       |237            | 361            |361             |243            |
       |240            | 301            |362-376         |255            |
       |241            | 302            |                |               |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to MS 1251
       For the conversion of PC Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | PC Cyrillic   |    MS 1251     | PC Cyrillic    |   MS 1251     |
       |24             | 4              |242             |342            |
       |200            | 300            |243             |343            |
       |201            | 301            |244             |344            |
       |202            | 302            |245             |345            |
       |203            | 303            |246             |346            |
       |204            | 304            |247             |347            |
       |205            | 305            |250             |350            |
       |206            | 306            |251             |351            |
       |207            | 307            |252             |352            |
       |210            | 310            |253             |353            |
       |211            | 311            |254             |354            |
       |212            | 312            |255             |355            |
       |213            | 313            |256             |356            |
       |214            | 314            |257             |357            |
       |215            | 315            |260-337         |210            |
       |216            | 316            |340             |360            |
       |217            | 317            |341             |361            |
       |220            | 320            |342             |362            |
       |221            | 321            |343             |363            |
       |222            | 322            |344             |364            |
       |223            | 323            |345             |365            |
       |224            | 324            |346             |366            |
       |225            | 325            |347             |367            |
       |226            | 326            |350             |370            |
       |227            | 327            |351             |371            |
       |230            | 330            |352             |372            |
       |231            | 331            |353             |373            |
       |232            | 332            |354             |374            |
       |233            | 333            |355             |375            |
       |234            | 334            |356             |376            |
       |235            | 335            |357             |377            |
       |236            | 336            |360             |250            |
       |237            | 337            |361             |270            |
       |240            | 340            |362-376         |210            |
       |241            | 341            |                |               |
       +---------------+----------------+----------------+---------------+

   PC Cyrillic to Mac Cyrillic
       For the conversion of PC Cyrillic to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | PC Cyrillic   | Mac Cyrillic   | PC Cyrillic    | Mac Cyrillic  |
       |24             | 4              |341             |361            |
       |240            | 340            |342             |362            |
       |241            | 341            |343             |363            |
       |242            | 342            |344             |364            |
       |243            | 343            |345             |365            |
       |244            | 344            |346             |366            |
       |245            | 345            |347             |367            |
       |246            | 346            |350             |370            |
       |247            | 347            |351             |371            |
       |250            | 350            |352             |372            |
       |251            | 351            |353             |373            |
       |252            | 352            |354             |374            |
       |253            | 353            |355             |375            |
       |254            | 354            |356             |376            |
       |255            | 355            |357             |337            |
       |256            | 356            |360             |335            |
       |257            | 357            |361             |336            |
       |260-337        | 40             |362-376         |40             |
       |340            | 360            |                |               |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                    iconv_pc_cyr(5)
All times are GMT -4. The time now is 06:10 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy