Sponsored Content
Top Forums Shell Programming and Scripting Parsing a name Value pair file Post 302955017 by mksuneel on Monday 14th of September 2015 07:24:24 AM
Old 09-14-2015
Parsing a name Value pair file

Hi,

I have a file having rows as

Row1 : model=.1.3.6.1.4.1.9.1.1047,location=abc, pollgrp=PG_CISCO4, ifindex=3, ip=10.10.10.1,parttype=Interface, devtype=Router,part=GigabitEthernet0/1,ifmtu=1520
Row2 : model=.1.3.6.1.4.1.9.1.2047,pollgrp=PG_ABCD4,ifindex=3,contact=LMN,ip=20.20.20.1,devtype=Router,ifmt u=2345
Row3:model=.1.3.6.1.4.1.9.1.3047,location=xyz,devtype=route,dwelf=xxxx

I need output as below
Code:
model;location;pollgrp;ifindex;contact;ip;parttype;devtype;part;ifmtu;dwelf
.1.3.6.1.4.1.9.1.1047;abc;PG_CISCO4;3;;10.10.10.1;Interface;Router;GigabitEthernet0/1;1520;
.1.3.6.1.4.1.9.1.2047;;PG_ABCD4;3;LMN;20.20.20.1;;Router;;2345;
.1.3.6.1.4.1.9.1.3047;xyz;;;;;;route;;;xxxx

Can someone help me out?

Last edited by vbe; 09-14-2015 at 09:28 AM..
 

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies

2. Shell Programming and Scripting

Parsing with Name value pair and creating a normalized file

I have url string as follows and I need to parse the name value pair into fields /rows event_id date time payload 1329130951 20120214 22.30.40... (1 Reply)
Discussion started by: smee
1 Replies

3. Shell Programming and Scripting

Sort files as pair file

Hello, I am wondering if there is a way to sort file in directory by pair name : I am looking to get the extension .txt above the .archlike this if possible liste_NATIVE_HINDCAST_PSY1V2R2_R20120314.txt flag.NATIVE_HINDCAST_PSY1V2R2.R20120314.arch... (4 Replies)
Discussion started by: Aswex
4 Replies

4. AIX

How to find pair VIOS?

Hi, I have the scenario, that there 3 VIOS in a Frame in this 2 are in dual VIOS My question is how to find which VIOS are in dual? Also, any vios command to identify the pair member (hostname) of a dual VIOS Regards, Siva (3 Replies)
Discussion started by: ksgnathan
3 Replies

5. Shell Programming and Scripting

Pair wise comparisons

Hi, I have 25 groups and I need to perform all possible pairwise compariosns between them using the formula n(n-1)/2. SO in my case it will be 25(25-1)/2 which is equal to 300 comparisons. my 25 groups are FG1 FG2 FG3 FG4 FG5 NT5E CD44 CD44 CD44 AXL ADAM19 CCDC80 L1CAM L1CAM CD44... (1 Reply)
Discussion started by: Diya123
1 Replies

6. UNIX for Dummies Questions & Answers

Deleting a file with no corresponding pair

Hi, I am working with 2 sets of files (*csv and *asc) and I wanted to delete asc file with no corresponding csv counterpart. I did tried it manually but its been difficult working with a longer list of files. sample files in directory 20120601.csv 20120601_f1.asc 20120603.csv 20120602_f1.asc... (3 Replies)
Discussion started by: ida1215
3 Replies

7. Shell Programming and Scripting

awk name pair values

Team, I have a file like below FILE: NAM1,KEY1,VAL1 NAM1,KEY2,VAL2 NAM1,KEY3,VAL3 NAM2,KEY1,VALA NAM2,KEY2,VALB NAM2,KEY3,VALCOutput: I have to build commands like below <Script> VAL1 VAL2 VAL3 NAME1 <Script> VALA VALB VALC NAME2Can you please help with awk command i can use... (4 Replies)
Discussion started by: mallak
4 Replies

8. Programming

Calculate ratios for each pair in a given file

Hello, My input file looks like this #CHROM POS ID REF ALT QUAL FILTER INFO FORMAT Individual1 Individual2 Individual3 Individual4 Individual5 Individual6 22 10000 ID1 A ... (0 Replies)
Discussion started by: nans
0 Replies
lldptool(8)							       Linux							       lldptool(8)

NAME
LLDP-MED - Show / manipulate MED TLV configurations SYNOPSIS
lldptool -t -i ethx -V [ TLV_TYPE ] enableTx lldptool -T -i ethx -V [ TLV_TYPE ] enableTx = { yes | no } lldptool -T -i ethx -V LLDP-MED devtype = { class1 | class2 | class3 } lldptool -t -i ethx -V LLDP-MED devtype TLV_TYPE : = {LLDP-MED | medCap | medPolicy | medLoc | medPower | medHwRev | medFwRev | medSwRev | medSerNum | medManuf | medModel | medAssetID } DESCRIPTION
The LLDP-MED extensions support the Link Layer Discovery Protocol for Media Endpoint Devices defined in the ANSI/TIA-1057-2006 document. Each TLV can be configured as a class1 , class2 or class3 device. Class I devices are the most basic class of Endpoint Device, Class II devices support media stream capabilities and Class III devices directly support end users of the IP communication system. See ANS-TIA-1057 for clarification of class types. ARGUMENTS
enableTx Enables the TLV to be transmitted devtype Set or query the class type of the device. TLV_TYPE List of supported TLV specifiers applicable to Media Endpoint Devices. LLDP-MED apply arguments to all supported MED TLVs. medCAP LLDP-MED Capabilities TLV medPolicy LLDP-MED Network Policy TLV medLoc LLDP-MED Location TLV medPower LLDP-MED Extended Power-via-MDI TLV medHwRev LLDP-MED Hardware Revision TLV medFwRev LLDP-MED Firmware Revision TLV medSwRev LLDP-MED Software Revision TLV medSerNum LLDP-MED Serial Number TLV medManuf LLDP-MED Manufacturer Name TL medModel LLDP-MED Model Name TLV medAssetID LLDP-MED Asset ID TLV EXAMPLE &; USAGE Enable class1 MED device on eth2 lldptool -T -i eth2 -V LLDP-MED enableTx=yes devtype=class1 Query class type of MED on eth2 lldptool -t -i eth2 -V LLDP-MED -c devtype Query transmit state of medPolicy on device eth2 lldptool -t -i eth2 -V medPolicy -c enableTx SOURCE o Link Layer Discovery Protocol for Media Endpoint Devices (http://www.tiaonline.org/standards/technology/voip/documents/ANSI- TIA-1057_final_for_publication.pdf) NOTES
SEE ALSO
lldptool(8), lldpad(8) AUTHOR
John Fastabend open-lldp June 2011 lldptool(8)
All times are GMT -4. The time now is 04:05 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy