awk one liner - change Output Record Separator
September 1st, 2009 | Published in Unix
convert multi field line separated with a certain character to rows
Measurement Time|ss7OctetsReceivedPerLinkBb.1.2.0.0.35|ss7OctetsSentPerLinkBb.1.2.0.0.35|ss7OctetsReceivedPerLinkBb.1.4.0.0.35|ss7OctetsSentPerLinkBb.1.4.0.0.35|ss7OctetsReceivedPerAssociation.1.2.513|ss7OctetsSentPerAssociation.1.2.513|ss7OctetsReceivedPerAssociation.1.2.519|ss7OctetsSentPerAssociation.1.2.519|ss7OctetsReceivedPerAssociation.1.3.1|ss7OctetsSentPerAssociation.1.3.1|ss7OctetsReceivedPerAssociation.1.3.3|ss7OctetsSentPerAssociation.1.3.3|ss7OctetsReceivedPerAssociation.1.4.514|ss7OctetsSentPerAssociation.1.4.514|ss7OctetsReceivedPerAssociation.1.4.520|ss7OctetsSentPerAssociation.1.4.520|ss7OctetsReceivedPerAssociation.1.5.2|ss7OctetsSentPerAssociation.1.5.2|ss7OctetsReceivedPerAssociation.1.5.4|ss7OctetsSentPerAssociation.1.5.4|ss7MessageOrigCR|ss7MessageOrigDT1|ss7MessageOrigRLSD|ss7MessageOrigUDT|ss7MessageOrigXUDT|ss7MessageTermCR|ss7MessageTermDT1|ss7MessageTermRLSD|ss7MessageTermUDT|ss7MessageTermXUDT|ss7NoOfCurrRunConnTot|ss7AssocAvlForUP|ss7AssocUnavlForUP|ss7MSUDiscardError|ss7MessageDiscardedOPCScreening|ss7NoOfRunDialTot|ss7NoOfRunOpTot|ss7ProtocolErrorComp|ss7ProtocolErrorTraA|ss7ProtocolErrorTraD|ss7SPInaccess|ss7TCMessageReceive|ss7TCMessageSent
use one liner awk below :
nawk 'BEGIN{RS="|"} {print $0}' filename
and the result is:
Measurement Time ss7OctetsReceivedPerLinkBb.1.2.0.0.35 ss7OctetsSentPerLinkBb.1.2.0.0.35 ss7OctetsReceivedPerLinkBb.1.4.0.0.35 ss7OctetsSentPerLinkBb.1.4.0.0.35 ss7OctetsReceivedPerAssociation.1.2.513 ss7OctetsSentPerAssociation.1.2.513 ss7OctetsReceivedPerAssociation.1.2.519 ss7OctetsSentPerAssociation.1.2.519 ss7OctetsReceivedPerAssociation.1.3.1 ss7OctetsSentPerAssociation.1.3.1 ss7OctetsReceivedPerAssociation.1.3.3 ss7OctetsSentPerAssociation.1.3.3 ss7OctetsReceivedPerAssociation.1.4.514 ss7OctetsSentPerAssociation.1.4.514 ss7OctetsReceivedPerAssociation.1.4.520 ss7OctetsSentPerAssociation.1.4.520 ss7OctetsReceivedPerAssociation.1.5.2 ss7OctetsSentPerAssociation.1.5.2 ss7OctetsReceivedPerAssociation.1.5.4 ss7OctetsSentPerAssociation.1.5.4 ss7MessageOrigCR ss7MessageOrigDT1 ss7MessageOrigRLSD ss7MessageOrigUDT ss7MessageOrigXUDT ss7MessageTermCR ss7MessageTermDT1 ss7MessageTermRLSD ss7MessageTermUDT ss7MessageTermXUDT ss7NoOfCurrRunConnTot ss7AssocAvlForUP ss7AssocUnavlForUP ss7MSUDiscardError ss7MessageDiscardedOPCScreening ss7NoOfRunDialTot ss7NoOfRunOpTot ss7ProtocolErrorComp ss7ProtocolErrorTraA ss7ProtocolErrorTraD ss7SPInaccess ss7TCMessageReceive ss7TCMessageSent
« « First Media Internet Cable
