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
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
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
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
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
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
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
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
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
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
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_maz
iconv_maz(5) Standards, Environments, and Macros iconv_maz(5)
NAME
iconv_maz - code set conversion tables for Mazovia
DESCRIPTION
The following code set conversions are supported:
+--------------------------------------------------------------------+
| Code Set Conversions Supported |
+--------------+--------+--------------+--------+--------------------+
| Code |Symbol |Target Code |Symbol | Target |
+--------------+--------+--------------+--------+--------------------+
|Output | | | | |
+--------------+--------+--------------+--------+--------------------+
|Mazovia |maz |ISO 8859-2 |iso2 | ISO Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|Mazovia |maz |MS 1250 |win2 | Windows Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|Mazovia |maz |MS 852 |dos2 | MS-DOS Latin 2 |
+--------------+--------+--------------+--------+--------------------+
|Mazovia |maz |DHN |dhn | Dom Hanlowy Nauki |
+--------------+--------+--------------+--------+--------------------+
CONVERSIONS
The conversions are performed according to the following tables. All values in the tables are given in octal.
Mazovia to ISO 8859-2
For the conversion of Mazovia to ISO 8859-2, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| Mazovia | ISO 8859-2 | Mazovia | ISO 8859-2 |
|24-177 | 40 |230 |246 |
|200 | 307 |231 |326 |
|201 | 374 |232 |334 |
|202 | 351 |233 |40 |
|203 | 342 |234 |243 |
|204 | 344 |235 |40 |
|205 | 40 |236 |266 |
|206 | 261 |237 |40 |
|207 | 347 |240 |254 |
|210 | 40 |241 |257 |
|211 | 353 |242 |363 |
|212-213 | 40 |243 |323 |
|214 | 356 |244 |361 |
|215 | 346 |245 |321 |
|216 | 304 |246 |274 |
|217 | 241 |247 |277 |
|220 | 312 |250-340 |40 |
|221 | 352 |341 |337 |
|222 | 263 |342-365 |40 |
|223 | 364 |366 |367 |
|224 | 366 |367 |40 |
|225 | 306 |370 |260 |
|226-227 | 40 |371-376 |40 |
|256 | 201 | | |
+---------------+----------------+----------------+---------------+
Mazovia to MS 1250
For the conversion of Mazovia to MS 1250, all characters not in the following table are mapped unchanged.
+---------------+----------------+----------------+---------------+
| Mazovia | MS 1250 | Mazovia | MS 1250 |
|200 | 307 |236 |234 |
|201 | 374 |237 |40 |
|202 | 351 |240 |217 |
|203 | 342 |241 |257 |
|204 | 344 |242 |363 |
|205 | 40 |243 |323 |
|206 | 271 |244 |361 |
|207 | 347 |245 |321 |
|210 | 40 |246 |237 |
|211 | 353 |247 |277 |
|212-213 | 40 |250-251 |40 |
|214 | 356 |252 |254 |
|215 | 346 |253-255 |40 |
|216 | 304 |256 |253 |
|217 | 245 |257 |273 |
|220 | 312 |260-340 |40 |
|221 | 352 |341 |337 |
|222 | 263 |342-345 |40 |
|223 | 364 |346 |265 |
|224 | 366 |347-360 |40 |
|225 | 306 |361 |261 |
|226-227 | 40 |362-365 |0 |
|230 | 214 |366 |367 |
|231 | 326 |367 |40 |
|232 | 334 |370 |260 |
|233 | 40 |371 |40 |
|234 | 243 |372 |267 |
|235 | 40 |373-376 |40 |
|274 | 212 | | |
+---------------+----------------+----------------+---------------+
Mazovia to MS 852
For the conversion of Mazovia to MS 852, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| Mazovia | MS 852 | Mazovia | MS 852 |
|205 | 40 |234 |235 |
|206 | 245 |235 |40 |
|210-213 | 40 |236 |230 |
|215 | 206 |237 |40 |
|217 | 244 |240 |215 |
|220 | 250 |241 |275 |
|221 | 251 |243 |340 |
|222 | 210 |244 |344 |
|225 | 217 |245 |343 |
|226-227 | 40 |246 |253 |
|230 | 227 |247 |276 |
|233 | 40 |250-375 |40 |
|227 | 327 | | |
+---------------+----------------+----------------+---------------+
Mazovia to DHN
For the conversion of Mazovia to DHN, all characters not in the following table are mapped unchanged.
+-----------------------------------------------------------------+
| | Conversions|Performed | |
| Mazovia | DHN | Mazovia | DHN |
|200-205 | 40 |234 |203 |
|206 | 211 |236 |217 |
|207-214 | 40 |240 |207 |
|215 | 212 |241 |210 |
|216 | 40 |242 |216 |
|217 | 200 |243 |205 |
|220 | 202 |244 |215 |
|221 | 214 |246 |220 |
|225 | 201 |247 |221 |
|230 | 206 | | |
+---------------+----------------+----------------+---------------+
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_maz(5)