Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk or sed script to remove strings
Top Forums Shell Programming and Scripting awk or sed script to remove strings Post 302721711 by aix_admin_007 on Thursday 25th of October 2012 04:29:14 PM
Old 10-25-2012
awk or sed script to remove strings
Below am trying to separate FA-7A:1, In output file it should display 7A 1

Quote:
Input file:
Symmetrix ID : 0001901
Device Identifier Type Dir:P
------ ---------------- ----- ----------------
08F7 10000000c9502ee3 FIBRE FA-7A:1
10000000c94f912a FIBRE FA-10A:1
10000000c97239cf FIBRE FA-7B:0
10000000c96fc9f1 FIBRE FA-10B:0
Symmetrix ID : 0001901
Device Identifier Type Dir:P
------ ---------------- ----- ----------------
39D1 10000000c9502ee3 FIBRE FA-7D:0
10000000c94f912a FIBRE FA-10D:0
Command am using
Quote:
cat input_file.txt | grep -v Device | grep -v Symmetrix | sed 's/-/ /g' | awk '/^ *$/{next;} length($1)!=4 { $0=l " " $0; } {l=$1 ; gsub("[:-]"," "); $3=$4="";} 1'

Code:
Gives same output as below format:
22B7 10000000c9720873   0
22B7 10000000c95d5d8b   0
22BB 10000000c97843a2   0
22BB 10000000c975adbd   0

Code:
Not showing FA ports as required format output:
 
01FB 10000000c97843a2   8C  0
01FB 10000000c96fb279   9C  0
22AF 10000000c97843a2   8C  0
22AF 10000000c975adbd   8C  0

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sed or awk script to remove text / or perform calculations from large CSV files

I have a large CSV files (e.g. 2 million records) and am hoping to do one of two things. I have been trying to use awk and sed but am a newbie and can't figure out how to get it to work. Any help you could offer would be greatly appreciated - I'm stuck trying to remove the colon and wildcards in... (6 Replies)
Discussion started by: metronomadic
6 Replies

2. Shell Programming and Scripting

Replace Strings with sed or awk

Hello i need some help with the usage of sed. Situation : 2 textfiles, file.in , file.out In the first textfile which is called file.in are the words for the substitution. Every word is in a new-line like : Firstsub Secondsub Thridsub ... In the second textflie wich is called file.out is... (5 Replies)
Discussion started by: Kingbruce
5 Replies

3. Shell Programming and Scripting

sed: remove characters between and including 2 strings

I have the following line: 4/23/2010 0:00:38.000: Copying $$3MSYDDC02$I would like to use sed (or similiar) to remove everthing between and including $ that appears in the line so it ends up like this. 4/23/2010 0:00:38.000: Copying 3MSYDDC02I have been trying these but i'm really just... (5 Replies)
Discussion started by: jelloir
5 Replies

4. Shell Programming and Scripting

Remove strings within range using sed

Hey folks I have a big file that contains junk data between the tags <point> and </point> and I need to delete it (including `<point>' and `</point>'). i.e. a = 1 <point> 123123 2342352 234231 234256 </point> print a needs to become a = 1 print a I'm certain that this is a... (10 Replies)
Discussion started by: ksk
10 Replies

5. Shell Programming and Scripting

Sed: Remove whitespace between two strings

I have a 13 number string, some whitespace, and then /mp3. I need to join them. Everyline that I need this for begins with "cd" (without the quotes). What it looks like now: cd media/Audio/WAVE/9781933976334 /mp3 What I want my output to be: cd media/Audio/WAVE/9781933976334/mp3 The 13... (7 Replies)
Discussion started by: glev2005
7 Replies

6. Shell Programming and Scripting

any savant ? using AWK/SED to remove newline character between two strings : conditional removal

I'd like to remove (do a pattern or precise replacement - this I can handle in SED using Regex ) ---AFTER THE 1ST Occurrence ( i.e. on the 2nd occurrence - from the 2nd to fourth occurance ) of a specific string : type 1 -- After the 1st occurrence of 1 string1 till the 1st occurrence of... (4 Replies)
Discussion started by: sieger007
4 Replies

7. Shell Programming and Scripting

Need the script to remove common strings,tags etc

I have a file say "example.xml" and the contents of this example.xml are <project name="platform/packages/wallpapers/Basic" path="packages/wallpapers/Basic" revision="225e410f054c4ad5c828b0fec9be1b47c4376711"/> <project name="platform/packages/wallpapers/Galaxy4"... (3 Replies)
Discussion started by: acdc
3 Replies

8. Shell Programming and Scripting

USING sed to remove multiple strings/words from a line

Hi I use sed comnand to remove occurance of one workd from a line. However I need to removed occurance of dufferent words in ne line. Original-1 Hi this is the END of my begining Comand sed s/"END"/"start"/g Output-1 Hi this is the start of my beginig But I have more... (9 Replies)
Discussion started by: mnassiri
9 Replies

9. Shell Programming and Scripting

How to remove certain character strings with awk?

Hi all, I need to remove DBPATH= and /db from the string below using awk (or sed, as it also exists on the machine). Input: DBPATH=/some/path/database/db Desired output: /some/path/database Thank you! (8 Replies)
Discussion started by: ejianu
8 Replies

10. Shell Programming and Scripting

awk to remove field and match strings to add text

In file1 field $18 is removed.... column header is "Otherinfo", then each line in file1 is used to search file2 for a match. When a match is found the last four strings in file2 are copied to file1. Maybe: cut -f1-17 file1 and then match each line to file2 file1 Chr Start End ... (6 Replies)
Discussion started by: cmccabe
6 Replies

LEARN ABOUT DEBIAN

ost_dir

ost::Dir(3)						     Library Functions Manual						       ost::Dir(3)

NAME

       ost::Dir -

       A low level portable directory class.

SYNOPSIS

       #include <file.h>

       Inherits ost::File.

   Public Member Functions
       Dir (const char *name=NULL)
       void open (const char *name)
       void close (void)
       virtual ~Dir ()
       const char * getName (void)
       const char * operator++ ()
       const char * operator++ (int)
       const char * operator* ()
       bool rewind (void)
       bool operator! ()
       bool isValid (void)

   Static Public Member Functions
       static bool create (const char *path, Attr attr=attrGroup)
       static bool remove (const char *path)
       static bool setPrefix (const char *path)
       static bool getPrefix (char *path, size_t size=256)

   Additional Inherited Members
Detailed Description
       A low level portable directory class.

       Used to support ccstd Directory container. This provides a basic mechanism for allocating and accessing file entries.

       Author:
	   David Sugar dyfet@ostel.com low level directory access class.

Constructor &; Destructor Documentation
   ost::Dir::Dir (const char *name = NULL)
   virtual ost::Dir::~Dir () [virtual]
Member Function Documentation
   void ost::Dir::close (void)
   static bool ost::Dir::create (const char *path, Attrattr = attrGroup) [static]
   const char* ost::Dir::getName (void)
   static bool ost::Dir::getPrefix (char *path, size_tsize = 256) [static]
   bool ost::Dir::isValid (void)
   void ost::Dir::open (const char *name)
   bool ost::Dir::operator! () [inline]
   const char* ost::Dir::operator* ()
   const char* ost::Dir::operator++ () [inline]
   const char* ost::Dir::operator++ (int) [inline]
   static bool ost::Dir::remove (const char *path) [static]
   bool ost::Dir::rewind (void)
   static bool ost::Dir::setPrefix (const char *path) [static]
Author
       Generated automatically by Doxygen for GNU CommonC++ from the source code.

GNU CommonC++							  Sat Jun 23 2012						       ost::Dir(3)
All times are GMT -4. The time now is 07:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy