Sed replace characters not equal to an expression

poldo · #1 (**permalink**) 09-03-2009

Hi all,

Suppose I have a file with the contents below, and I only want to print words %S_[A-Z] then | sort -u.

------------------------------
The %S_MSG that starts with '%.*s' is too long. Maximum length is %d.
The %S_MSG name '%.*s' contains more than the maximum number of prefixes. The maximum is %d.
The size (%d) given to the %S_MSG '%.*s' exceeds the maximum. The largest size allowed is %d.
%S_MSG is not allowed in %S_MSG.
The %S_MSG '%.*s' is out of the range of machine representation (%d bytes).
'%.*s' is not a recognized %S_MSG.
%s permission denied on object %S_OBJID, database %S_DBID, owner %.*s
%s permission denied on column %.*s of object %S_OBJID, database %S_DBID, owner %.*s
The column %.*s in table %.*s does not allow null values.%S_EED
Precision error during %S_MSG conversion of %s value '%s' to a %s field.
Scale error during %S_MSG conversion of %s value '%s' to a %s field.
Domain error during %S_MSG conversion of %s value '%s' to a %s field.
Arithmetic overflow during %S_MSG conversion of %s value '%s' to a %s field .
Syntax error during %S_MSG conversion of %s value '%s' to a %s field.
%s permission denied, database %S_DBID, owner %.*s
------------------------------------------

I'm trying to get the output like below
%S_MSG
%S_DBID
...
...

Problem is i don't know how many characters there are after the %S_, only that these are all caps.

I'm kind of new here also and any help is appreciated. I usually go here to look for help and tips in scripting.

Thanks

Tytalus · #2 (**permalink**) 09-03-2009

sounds like you want something like:

Code:

#  sed 's/.*\(%S_[A-Z]*\).*/\1/g' file1 | sort -u
%S_DBID
%S_EED
%S_MSG

HTH

poldo · #3 (**permalink**) 09-03-2009

Wow that's just awesome! I've been trying different things and never came up with one working. Thanks!

malcomex999 · #4 (**permalink**) 09-03-2009

Actually after %S_, you are also having dot and comma after the capital letters but try this if it helps

Code:

 
sed 's/.*\(\%S\_[A-Z]*[ |\,|\.]\).*/\1/' infile | sort -u

pludi · #5 (**permalink**) 09-03-2009

Code:

perl -e 'while(<>){ while(/(%S_[A-Z]+)\b/g){ $seen{$1}=1;}} foreach (sort keys %seen){print $_,"\n";}' test.txt
%S_DBID
%S_EED
%S_MSG
%S_OBJID

poldo · #6 (**permalink**) 09-10-2009

hey, thanks pludi. although i'm not that familiar with pearl.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Regular Expression to match repeated characters	jambesh	Shell Programming and Scripting	4	08-22-2009 01:51 AM
Regular Expression - Replace if x contains y except if...	not4google	UNIX for Dummies Questions & Answers	4	03-04-2009 03:36 PM
Replace if regex on specific column matches expression?	EXT3FSCK	Shell Programming and Scripting	5	11-25-2008 02:00 PM
Want to replace characters	arndorff	Shell Programming and Scripting	5	01-29-2008 04:05 PM
Replace Characters...	lgardner17325	UNIX for Dummies Questions & Answers	8	10-26-2006 06:04 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by