Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Getting required fields from a text file in UNIX
Top Forums Shell Programming and Scripting Getting required fields from a text file in UNIX Post 302329739 by rdhanek on Monday 29th of June 2009 10:00:54 AM
Old 06-29-2009
Getting required fields from a text file in UNIX
My data is something like as shown below. Out of this i want the details of alarms (ex: 1947147711,1947147081......) and the fields( ex :sw=tacmwafabb9:shelf=1:slot=5-2:pport=2)
Once i have these details separated, i want the count of these excluding the duplicates. What is the best possible way to get this?


sample data:
Code:
(06/25/2009 00:03:35.674)( No default rules found for alarm:1947147711
(06/25/2009 00:03:35.676)(:ERROR) No rule found for alarm: sw=tacmwafabb9:shelf=1:slot=5-2port=2
(06/25/2009 00:03:42.198)( No default rules found for alarm:1947147081
(06/25/2009 00:03:42.200)(:ERROR) No rule found for alarm: sw=mdfdor33dsm:slot=9:pport=1:channel=1:lport=1
(06/25/2009 00:03:51.026)(:) No default rules found for alarm:1947147493
(06/25/2009 00:03:51.028)(:ERROR) No rule found for alarm: sw=lscrnmmabb7:shelf=1:slot=13-2:pport=6
(06/25/2009 00:03:53.961)(:) No default rules found for alarm:1947147711

Output required :
Code:
Alarm id Port
1947147711 sw=tacmwafabb9:shelf=1:slot=5-2:pport=2
1947147081 sw=mdfdor33dsm:slot=9:pport=1:channel=1:lport=1
1947147493 sw=lscrnmmabb7:shelf=1:slot=13-2:pport=6

Last edited by otheus; 06-30-2009 at 06:17 AM.. Reason: codetags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need a Help with sort a text file with some fields

Ive got a file called listacdrs with this structure: 01/09/2006 12:13 p.m. 1.046.528 CF0155.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0156.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0157.DAT 01/09/2006 12:13 p.m. 1.046.528 CF0158.DAT 01/09/2006 12:14 p.m. ... (3 Replies)
Discussion started by: alexcol
3 Replies

2. UNIX for Dummies Questions & Answers

extract fields from text file using delimiter!!

Hi All, I am new to unix scripting, please help me in solving this assignment.. I have a scenario, as follows: 1. i have a text file(read1.txt) with the following data sairam,123 kamal,122 etc.. 2. I have to write a unix... (6 Replies)
Discussion started by: G.K.K
6 Replies

3. Shell Programming and Scripting

how to convert fields from a text file to excel columns

i have this file which has the following contents: ,-0.3000 ,-0.3000 ,-0.3000 ,-0.9000 ,-0.9000 ,-0.9000 i would like to get this: -0.3-0.9-0.3-0.9-0.3-0.9 so far i am trying: awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2 any help... (4 Replies)
Discussion started by: npatwardhan
4 Replies

4. Shell Programming and Scripting

Getting required fields from a test file in required fromat in unix

My data is something like shown below. date1 date2 aaa bbbb ccccc date3 date4 dddd eeeeeee ffffffffff ggggg hh I want the output like this date1date2 aaa eeeeee I serached in the forum but didn't find the exact matching solution. Please help. (7 Replies)
Discussion started by: rdhanek
7 Replies

5. Shell Programming and Scripting

How to search for blank fields in a text file from a certain position?

Sample txt file : OK00001111112| OK00003443434|skjdaskldj OK32812983918|asidisoado OK00000000001| ZM02910291029|sldkjaslkjdasldjk what would be the shell script to figure out the blank space (if any) after the pipe sign? (4 Replies)
Discussion started by: chatwithsaurav
4 Replies

6. Shell Programming and Scripting

Parse file for fields and specific text

I have a file of ~500,000 entries in the following: file.txt chr1 11868 12227 ENSG00000223972.5 . + HAVANA exon . gene_id "ENSG00000223972.5"; transcript_id "ENST00000456328.2"; gene_type "transcribed_unprocessed_pseudogene"; gene_status "KNOWN"; gene_name "DDX11L1"; transcript_type... (17 Replies)
Discussion started by: cmccabe
17 Replies

7. Shell Programming and Scripting

How to Modify a file content in UNIX and sort for only required fields ?

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

8. Shell Programming and Scripting

How to identify varying unique fields values from a text file in UNIX?

Hi, I have a huge unsorted text file. We wanted to identify the unique field values in a line and consider those fields as a primary key for a table in upstream system. Basically, the process or script should fetch the values from each line that are unique compared to the rest of the lines in... (13 Replies)
Discussion started by: manikandan23
13 Replies

9. Shell Programming and Scripting

Rearrange fields of delimited text file

I want to rearrange the fields of delimited text file after sorting first line (only): input file: a_13;a_2;a_1;a_10 13;2;1;10 the result should be: a_1;a_2;a_10;a_13 1;2;10;13 any help would be appreciated andy (20 Replies)
Discussion started by: andy2000
20 Replies

10. UNIX for Beginners Questions & Answers

How to search a text in file and retrieve required lines following it with UNIX command?

I have requirement to search for a text in the file and retrieve required lines that is user defined with unix command. Eg: Find the text UNIX in the below file and need to return Test 8 & Test 9 Test 1 Test 2 Test 3 Test 4 UNIX Test 5 Test 6 Test 7 Test 8 Test 9 Result can... (8 Replies)
Discussion started by: Arunkumarsak4
8 Replies

LEARN ABOUT DEBIAN

vblade

vblade(8)						      System Manager's Manual							 vblade(8)

NAME

       vblade, vbladed - export data via ATA over Ethernet

SYNOPSIS

       vblade [ -m mac[,mac...] ] shelf slot netif filename

DESCRIPTION

       The vblade command starts a process that uses raw sockets to perform ATA over Ethernet, acting like a virtual EtherDrive (R) blade.

       The vbladed script can be used to daemonize the vblade process, detaching it from your terminal and sending its output to the system logs.

   Arguments
       shelf  This should be the shelf address (major AoE address) of the AoE device to create.

       slot   This should be the slot address (minor AoE address) of the AoE device to create.

       netif  The name of the ethernet network interface to use for AoE communications.

       filename
	      The name of the regular file or block device to export.

   Options
       -b     The  -b  flag  takes  an argument, the advertised buffer count, specifying the maximum number of outstanding messages the server can
	      queue for processing.

       -d     The -d flag selects O_DIRECT mode for accessing the underlying block device.

       -s     The -s flag selects O_SYNC mode for accessing the underlying block device, so all writes are committed to disk before  returning	to
	      the client.

       -r     The -r flag restricts the export of the device to be read-only.

       -m     The  -m flag takes an argument, a comma separated list of MAC addresses permitted access to the vblade.  A MAC address can be speci-
	      fied in upper or lower case, with or without colons.

EXAMPLE

       In this example, the root user on a host named nai exports a file named "3TB" to the LAN on eth0  using	AoE  shelf  address  11  and  slot
       address 1.  The process runs in the foreground.	Using vbladed would have resulted in the process running as a daemon in the background.

	      nai:~# vblade 11 1 eth0 /data/3TB

BUGS

       Users of Jumbo frames should read the README file distributed with vblade to learn about a workaround for kernel buffering limitations.

AUTHOR

       Brantley Coile (brantley@coraid.com)

																	 vblade(8)
All times are GMT -4. The time now is 04:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy