https://community.splunk.com/t5/Getting-Data-In/Extracting-data-from-text-file-that-is-delimited-by-space/m-p/572352#M101291 <P>I wanted to extract the data for every node. As you can see the pg-2 and ss7-2 are the nodes and below is the information for the node. How do I extract the percentage value? I want to find the maximum percentage for every node.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Azwaliyana_0-1635208094627.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16588i98994A65C9BC8112/image-size/medium?v=v2&amp;px=400" role="button" title="Azwaliyana_0-1635208094627.png" alt="Azwaliyana_0-1635208094627.png" /></span></P><P>&nbsp;</P> Tue, 26 Oct 2021 00:32:15 GMT Azwaliyana 2021-10-26T00:32:15Z https://community.splunk.com/t5/Getting-Data-In/Extracting-data-from-text-file-that-is-delimited-by-space/m-p/572352#M101291 <P>I wanted to extract the data for every node. As you can see the pg-2 and ss7-2 are the nodes and below is the information for the node. How do I extract the percentage value? I want to find the maximum percentage for every node.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Azwaliyana_0-1635208094627.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/16588i98994A65C9BC8112/image-size/medium?v=v2&amp;px=400" role="button" title="Azwaliyana_0-1635208094627.png" alt="Azwaliyana_0-1635208094627.png" /></span></P><P>&nbsp;</P> Tue, 26 Oct 2021 00:32:15 GMT https://community.splunk.com/t5/Getting-Data-In/Extracting-data-from-text-file-that-is-delimited-by-space/m-p/572352#M101291 Azwaliyana 2021-10-26T00:32:15Z https://community.splunk.com/t5/Getting-Data-In/Extracting-data-from-text-file-that-is-delimited-by-space/m-p/572481#M101316 <P>Check out the <FONT face="courier new,courier">multikv</FONT> command.&nbsp; It will parse the columns into fields for you.&nbsp; You'll probably want to have separate events for each node, however.</P> Tue, 26 Oct 2021 14:56:36 GMT https://community.splunk.com/t5/Getting-Data-In/Extracting-data-from-text-file-that-is-delimited-by-space/m-p/572481#M101316 richgalloway 2021-10-26T14:56:36Z