Substring using cut/awk/sed Post: 302464388

Sponsored Content

Top Forums Shell Programming and Scripting Substring using cut/awk/sed Post 302464388 by ctsgnb on Wednesday 20th of October 2010 04:09:07 AM

10-20-2010

Registered User

sed will try to match the biggest pattern possible

Code:

# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\([0-9][0-9]\)/\1,\2,&/p'
MPMTR20,00,20100706043000.txt
# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\([0-9][0-9]\)/\1,\2,&/gp'
MPMTR20,00,20100706043000.txt
# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\([0-9][0-9]\)/\1,\2,&/1p'
MPMTR20,00,20100706043000.txt
#

and the & will be what is matched between the / / but it looks like a right expansion is performed since the .txt still remains

Note : The following will match nothing whereas we could have thought of a reverse search for the pattern like :
20100706043000
2010070604300
201007060430
20100706043
2010070604
...
see :

Code:

# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\([0-9][0-9]\)/\1,\2,&/2p'
# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\([0-9][0-9]\)/\1,\2,&/3p'
#

Note : that the \1 and \2 have their left and right expansion automatically performed even if not explicitly specified in the $ ...$ matching : look

Code:

# echo MPMTR20100706043000.txt|sed -n -e 's/\([0-9][0-9]\).*\(3[0-9][0-9]\)/\1,\2,&/p'
MPMTR20,300,20100706043000.txt

Last edited by ctsgnb; 10-20-2010 at 05:45 AM..

ctsgnb

View Public Profile for ctsgnb

Find all posts by ctsgnb

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cut vs. sed vs. awk ?

hi again...need new help guys:p the file contains following infos... users/abc/bla1.exe newusers/defgh/ik/albg2.exe users2/opww/ertz/qqwertzu/rwerwew.exe how to get the file content into... users/abc/ newusers/defgh/ik/ users2/opww/ertz/qqwertzu/ with... you can erase the...

2. Shell Programming and Scripting

sed, grep, awk, regex -- extracting a matched substring from a file/string

Ok, I'm stumped and can't seem to find relevant info. (I'm not even sure, I might have asked something similar before.): I'm trying to use shell scripting/UNIX commands to extract URLs from a fairly large web page, with a view to ultimately wrapping this in PHP with exec() and including the...

3. Shell Programming and Scripting

awk,sed or cut problem

Good afternoon, Sir's, I would like to seek your assistance regarding on this matter. $cat file1 111 aaaa bbb aass aaa files file1 temp temp1 pix 222 11 22 1 33 44 desired output: aaaa bbb aass files file1 temp1 222 11 22 1 33 44 thanks

4. Shell Programming and Scripting

cut in sed/awk

Hi Can i have an example where i should be able to cut columns (like for eg cut -c 1-3) in sed or awk. Regards Dhana

5. Shell Programming and Scripting

Sed Awk Cut Grep Combination Help ?

I have been reading for a few hours trying to educate myself enough to accomplish this task, so please know I have performed some research. Unfortunately, I am not a *NIX scripting expert, or a coder. I come from a network background instead. SO, here is my desired outcome. I have some Cisco...

6. Shell Programming and Scripting

Sed or awk cut all lines after word

Hi, sorry for newbie question :confused: can't find how to cut ? from 1000 2000 word some text1.... 100 200 300 word some text2.... 10 20 30 abc word some text3.... to some text1.... some text2.... some text3....

7. Shell Programming and Scripting

Substring using sed or awk

I am trying to get a substring from a string stored in a variable. I tried sed with a bit help from this forum, but not successful. Here is my problem. My string is: "REPLYFILE=myfile.txt" And I need: myfile.txt (everything after the = symbol). My string is: "myfile.txt.gz.20091120.enc...

8. Shell Programming and Scripting

editing file with awk cut and sed

HI All, I am new to unix. I have a file would like to do some editing by using awk, cut and sed. Could anyone help? This file contain 100 lines. There are one line for example: 2,"102343454",5060,"579668","579668","579668","SIP",,,"825922","035885221283026",1,268,"00:59:00.782 APR 17...

9. Shell Programming and Scripting

Extract a substring using SED/AWK

Hi All, I have a log file in which name and version of applications are coming in the following format name It may look like following, based on the name of the application and version: XYZ OR xyz OR XyZ OR xyz I want to separate out the name and version and store them into variables....

10. Shell Programming and Scripting

Using sed, awk or perl to remove substring of all lines except the first

Greetings All, I would like to find all occurences of a pattern and delete a substring from the all matching lines EXCEPT the first. For example: 1234::group:user1,user2,user3,blah1,blah2,blah3 2222::othergroup:user9,user8 4444::othergroup2:user3,blah,blah,user1 1234::group3:user5,user1 ...

LEARN ABOUT DEBIAN

colorreset

COLORS(3)						   libbash colors Library Manual						 COLORS(3)

NAME

     colors -- libbash library for setting tty colors.

SYNOPSIS

     colorSet	  <color>
     colorReset
     colorPrint   [<indent>] <color> <text>
     colorPrintN  [<indent>] <color> <text>

DESCRIPTION

   General
     colors is a collection of functions that make it very easy to put colored text on tty.

     The function list:
	   colorSet	    Sets the color of the prints to the tty to COLOR
	   colorReset	    Resets current tty color back to normal
	   colorPrint	    Prints TEXT in the color COLOR indented by INDENT (without adding a newline)
	   colorPrintN	    The same as colorPrint, but trailing newline is added

     Detailed interface description follows.

   Available colors:
	   Green
	   Red
	   Yellow
	   White
     The color parameter is non-case-sensitive (i.e. RED, red, ReD, and all the other forms are valid and are the same as Red).

FUNCTIONS DESCRIPTIONS

   colorSet <color>
     Sets the current printing color to color.

   colorReset
     Resets current tty color back to normal.

   colorPrint [<indent>] <color>
     Prints text using the color color indented by indent (without adding a newline).

     Parameters:

       <indent>
	 The column to move to before start printing.  This parameter is optional. If ommitted - start output from current cursor position.

       <color>
	 The color to use.

       <color>
	 The text to print.

   colorPrintN [<indent>] <color>
     The same as colorPrint, except a trailing newline is added.

EXAMPLES

     Printing a green 'Hello World' with a newline:

	  Using colorSet:
		  $ colorSet green
		  $ echo 'Hello World'
		  $ colorReset

	  Using colorPrint:
		  $ colorPrint 'Hello World'; echo

	  Using colorPrintN:
		  $ colorPrintN 'Hello World'

AUTHORS

     Hai Zaar <haizaar@haizaar.com>
     Gil Ran <gil@ran4.net>

SEE ALSO

     ldbash(1), libbash(1)

Linux								       Epoch								     Linux

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cut vs. sed vs. awk ?

Discussion started by: svennie

2. Shell Programming and Scripting

sed, grep, awk, regex -- extracting a matched substring from a file/string

Discussion started by: ropers

3. Shell Programming and Scripting

awk,sed or cut problem

Discussion started by: invinzin21

4. Shell Programming and Scripting

cut in sed/awk

Discussion started by: dhanamurthy

5. Shell Programming and Scripting

Sed Awk Cut Grep Combination Help ?

Discussion started by: abbzer0

6. Shell Programming and Scripting

Sed or awk cut all lines after word

Discussion started by: Trump

7. Shell Programming and Scripting

Substring using sed or awk

Discussion started by: jamjam10k

8. Shell Programming and Scripting

editing file with awk cut and sed

Discussion started by: mimilaw

9. Shell Programming and Scripting

Extract a substring using SED/AWK

Discussion started by: bhaskar_m

10. Shell Programming and Scripting

Using sed, awk or perl to remove substring of all lines except the first

Discussion started by: jacksolm

LEARN ABOUT DEBIAN

colorreset