SNMP data parsing

[raki]

Hi

I have taken SNMP data into splunk through a CSV conversion of polled data. The sample data looks as below

1.cgdAnswerType.173, .1.3.6.1.4.1.9.9.595.1.5.2.1.2.173,Integer,2
2.cgdAnswerAddress.173, .1.3.6.1.4.1.9.9.595.1.5.2.1.4.173, Octetstring, 10.1.1.1
3.cgdAnswerName.173, .1.3.6.1.4.1.9.9.595.1.5.2.1.5.173,OctetString,www.example.com

The challenge I have is
a) the common factor is a random number and it is part of the field and not a value. Also the value of one field is another field such as cgdAnswerName is www.example.com.
I tried extract with delimiters of '.' but didnt work out. How can I use 173 in this case as a field and
b) Table the output as
Number | cgdAnswertype =2 | cgdAnswerAddress = 10.1.1.1 | cgdAnswerName = www.example.com

Thanks in advance

[MarioM]

a) use rather regex field extraction. Fields and field extractions

b) use the table command. Table