Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sed Awk Cut Grep Combination Help ?
Top Forums Shell Programming and Scripting Sed Awk Cut Grep Combination Help ? Post 302294822 by ripat on Friday 6th of March 2009 02:34:04 AM
Old 03-06-2009
If your awk version supports the sub() string function *and* if your record always have the same layout, here is another way of doing it:

Code:
awk  'BEGIN{RS="\n\n"; FS="\n"}{sub(/^.+State/, "State", $2); sub(/Max.+$/, "", $14); print $1,$2,$14}' file

Or, if you hate the one-liner style of coding:
Code:
awk  '
BEGIN{
	RS="\n\n"
	FS="\n"
}
{
	sub(/^.+State/, "State", $2)
	sub(/Max.+$/, "", $14)
	print $1,$2,$14
}' file

Edit: By reading the OP, I just realized that I stopped at the first request. So, go for the Radoulov's snippet. I can't think of anything better.
Last edited by ripat; 03-06-2009 at 03:44 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed, grep, cut or combine?

I am a beginner at shell scripting, actually i am working on my first script right now. Anyway i have searched the world how to grep two letters from each word (it will always just be two words). For example: Example Blablabla I want my script to cut out Ex (from the first word) and Bl... (4 Replies)
Discussion started by: maskot
4 Replies

2. Shell Programming and Scripting

cut sed grep or other?

Hi Is there a way to cut the last two characters off a word or number given that this word or number can be of varying length? I have tried something like TEST=`echo $OLD | cut -c 1-5` where $OLD is a variable containing a number like 1234567 which gives a result of 12345. This is fine... (4 Replies)
Discussion started by: rleebife
4 Replies

3. 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 (12 Replies)
Discussion started by: dhanamurthy
12 Replies

4. UNIX for Dummies Questions & Answers

Awk/sed solution for grep,cut

Hi, From the file "example" with lines like below, I need the int value associated with ENG , i.e, 123 SUB: ENG123, GROUP 1 SUB: HIS124, GROUP 1 .. .. Normally , i do grep ENG example | cut -d ' ' -f 2 | cut -c 4-6 Is it possible to do it in simpler way using awk/sed ? ... (5 Replies)
Discussion started by: priyam
5 Replies

5. Shell Programming and Scripting

Using grep and cut within awk

Hi My input file looks like as follows: say a.txt "aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd" "aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd" "aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd" "aaaa cc","224 AW","ss cccccc","P06 09/10","dddddd" "aaaa cc","224 AW","ss... (5 Replies)
Discussion started by: bittoo
5 Replies

6. Shell Programming and Scripting

Advice using cut & echo combination commands

Hi, I am cutting data from a fixed length test file and then writing out a new record using the echo command, the problem I have is how to stop multiple spaces from being written to the output file as a single space. Example: cat filea | while read line do field1=`echo $line | cut -c1-2` ... (6 Replies)
Discussion started by: dc18
6 Replies

7. Shell Programming and Scripting

GREP/CUT/AWK to Arrays

hi people, I have a text file containing data, seperated by TAB. I want to process this tab'ed data as variable. how can I assign this? Ex: Code: 11aaa 12000 13aaa 14aaa 15aaa 16aaa 17aaa 21aaa 22000 23aaa 24aaa 25aaa 26aaa 27aaa 31aaa 32000 33aaa 34aaa 35aaa 36aaa 37aaa... (1 Reply)
Discussion started by: gc_sw
1 Replies

8. Shell Programming and Scripting

Using a combination of sort/cut/grep/awk/join/paste/sed

I have a file and need to only select users that have a shell of “/bin/bash” in the line using awk or sed please help (4 Replies)
Discussion started by: boyboy1212
4 Replies

9. UNIX for Dummies Questions & Answers

Print/cut/grep/sed/ date yyyymmdd on the filename only.

I have this filename "RBD_EXTRACT_a3468_d20131118.tar.gz" and I would like print out the "yyyymmdd" only. I use this command below, but if different command like cut or print....etc. Thanks ls RBD_EXTRACT* | sed 's/.*\(........\).tar.gz$/\1/' > test.txt (9 Replies)
Discussion started by: dotran
9 Replies

LEARN ABOUT MOJAVE

datetime::locale::tn5.18

DateTime::Locale::tn(3) 				User Contributed Perl Documentation				   DateTime::Locale::tn(3)

NAME

       DateTime::Locale::tn

SYNOPSIS

	 use DateTime;

	 my $dt = DateTime->now( locale => 'tn' );
	 print $dt->month_name();

DESCRIPTION

       This is the DateTime locale package for Tswana.

DATA

       This locale inherits from the DateTime::Locale::root locale.

       It contains the following data.

   Days
       Wide (format)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (format)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (format)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

       Wide (stand-alone)

	 Mosopulogo
	 Labobedi
	 Laboraro
	 Labone
	 Labotlhano
	 Matlhatso
	 Tshipi

       Abbreviated (stand-alone)

	 Mos
	 Bed
	 Rar
	 Ne
	 Tla
	 Mat
	 Tsh

       Narrow (stand-alone)

	 2
	 3
	 4
	 5
	 6
	 7
	 1

   Months
       Wide (format)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (format)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (format)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

       Wide (stand-alone)

	 Ferikgong
	 Tlhakole
	 Mopitlo
	 Moranang
	 Motsheganang
	 Seetebosigo
	 Phukwi
	 Phatwe
	 Lwetse
	 Diphalane
	 Ngwanatsele
	 Sedimonthole

       Abbreviated (stand-alone)

	 Fer
	 Tlh
	 Mop
	 Mor
	 Mot
	 See
	 Phu
	 Pha
	 Lwe
	 Dip
	 Ngw
	 Sed

       Narrow (stand-alone)

	 1
	 2
	 3
	 4
	 5
	 6
	 7
	 8
	 9
	 10
	 11
	 12

   Quarters
       Wide (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (format)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (format)

	 1
	 2
	 3
	 4

       Wide (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Abbreviated (stand-alone)

	 Q1
	 Q2
	 Q3
	 Q4

       Narrow (stand-alone)

	 1
	 2
	 3
	 4

   Eras
       Wide

	 BC
	 AD

       Abbreviated

	 BC
	 AD

       Narrow

	 BC
	 AD

   Date Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22
	 -0010-09-15T04:44:23 = -10 Lwetse 15

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

       Short

	  2008-02-05T18:30:30 = 08/02/05
	  1995-12-22T09:05:02 = 95/12/22
	 -0010-09-15T04:44:23 = -10/09/15

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5
	  1995-12-22T09:05:02 = 1995 Sed 22
	 -0010-09-15T04:44:23 = -10 Lwe 15

   Time Formats
       Full

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 18:30:30 UTC
	  1995-12-22T09:05:02 = 09:05:02 UTC
	 -0010-09-15T04:44:23 = 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

       Short

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 09:05
	 -0010-09-15T04:44:23 = 04:44

       Default

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 09:05:02
	 -0010-09-15T04:44:23 = 04:44:23

   Datetime Formats
       Full

	  2008-02-05T18:30:30 = Labobedi, 2008 Tlhakole 05 18:30:30 UTC
	  1995-12-22T09:05:02 = Labotlhano, 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = Matlhatso, -10 Lwetse 15 04:44:23 UTC

       Long

	  2008-02-05T18:30:30 = 2008 Tlhakole 5 18:30:30 UTC
	  1995-12-22T09:05:02 = 1995 Sedimonthole 22 09:05:02 UTC
	 -0010-09-15T04:44:23 = -10 Lwetse 15 04:44:23 UTC

       Medium

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

       Short

	  2008-02-05T18:30:30 = 08/02/05 18:30
	  1995-12-22T09:05:02 = 95/12/22 09:05
	 -0010-09-15T04:44:23 = -10/09/15 04:44

       Default

	  2008-02-05T18:30:30 = 2008 Tlh 5 18:30:30
	  1995-12-22T09:05:02 = 1995 Sed 22 09:05:02
	 -0010-09-15T04:44:23 = -10 Lwe 15 04:44:23

   Available Formats
       d (d)

	  2008-02-05T18:30:30 = 5
	  1995-12-22T09:05:02 = 22
	 -0010-09-15T04:44:23 = 15

       EEEd (d EEE)

	  2008-02-05T18:30:30 = 5 Bed
	  1995-12-22T09:05:02 = 22 Tla
	 -0010-09-15T04:44:23 = 15 Mat

       Hm (H:mm)

	  2008-02-05T18:30:30 = 18:30
	  1995-12-22T09:05:02 = 9:05
	 -0010-09-15T04:44:23 = 4:44

       hm (h:mm a)

	  2008-02-05T18:30:30 = 6:30 PM
	  1995-12-22T09:05:02 = 9:05 AM
	 -0010-09-15T04:44:23 = 4:44 AM

       Hms (H:mm:ss)

	  2008-02-05T18:30:30 = 18:30:30
	  1995-12-22T09:05:02 = 9:05:02
	 -0010-09-15T04:44:23 = 4:44:23

       hms (h:mm:ss a)

	  2008-02-05T18:30:30 = 6:30:30 PM
	  1995-12-22T09:05:02 = 9:05:02 AM
	 -0010-09-15T04:44:23 = 4:44:23 AM

       M (L)

	  2008-02-05T18:30:30 = 2
	  1995-12-22T09:05:02 = 12
	 -0010-09-15T04:44:23 = 9

       Md (M-d)

	  2008-02-05T18:30:30 = 2-5
	  1995-12-22T09:05:02 = 12-22
	 -0010-09-15T04:44:23 = 9-15

       MEd (E, M-d)

	  2008-02-05T18:30:30 = Bed, 2-5
	  1995-12-22T09:05:02 = Tla, 12-22
	 -0010-09-15T04:44:23 = Mat, 9-15

       MMM (LLL)

	  2008-02-05T18:30:30 = Tlh
	  1995-12-22T09:05:02 = Sed
	 -0010-09-15T04:44:23 = Lwe

       MMMd (MMM d)

	  2008-02-05T18:30:30 = Tlh 5
	  1995-12-22T09:05:02 = Sed 22
	 -0010-09-15T04:44:23 = Lwe 15

       MMMEd (E MMM d)

	  2008-02-05T18:30:30 = Bed Tlh 5
	  1995-12-22T09:05:02 = Tla Sed 22
	 -0010-09-15T04:44:23 = Mat Lwe 15

       MMMMd (MMMM d)

	  2008-02-05T18:30:30 = Tlhakole 5
	  1995-12-22T09:05:02 = Sedimonthole 22
	 -0010-09-15T04:44:23 = Lwetse 15

       MMMMEd (E MMMM d)

	  2008-02-05T18:30:30 = Bed Tlhakole 5
	  1995-12-22T09:05:02 = Tla Sedimonthole 22
	 -0010-09-15T04:44:23 = Mat Lwetse 15

       ms (mm:ss)

	  2008-02-05T18:30:30 = 30:30
	  1995-12-22T09:05:02 = 05:02
	 -0010-09-15T04:44:23 = 44:23

       y (y)

	  2008-02-05T18:30:30 = 2008
	  1995-12-22T09:05:02 = 1995
	 -0010-09-15T04:44:23 = -10

       yM (y-M)

	  2008-02-05T18:30:30 = 2008-2
	  1995-12-22T09:05:02 = 1995-12
	 -0010-09-15T04:44:23 = -10-9

       yMEd (EEE, y-M-d)

	  2008-02-05T18:30:30 = Bed, 2008-2-5
	  1995-12-22T09:05:02 = Tla, 1995-12-22
	 -0010-09-15T04:44:23 = Mat, -10-9-15

       yMMM (y MMM)

	  2008-02-05T18:30:30 = 2008 Tlh
	  1995-12-22T09:05:02 = 1995 Sed
	 -0010-09-15T04:44:23 = -10 Lwe

       yMMMEd (EEE, y MMM d)

	  2008-02-05T18:30:30 = Bed, 2008 Tlh 5
	  1995-12-22T09:05:02 = Tla, 1995 Sed 22
	 -0010-09-15T04:44:23 = Mat, -10 Lwe 15

       yMMMM (y MMMM)

	  2008-02-05T18:30:30 = 2008 Tlhakole
	  1995-12-22T09:05:02 = 1995 Sedimonthole
	 -0010-09-15T04:44:23 = -10 Lwetse

       yQ (y Q)

	  2008-02-05T18:30:30 = 2008 1
	  1995-12-22T09:05:02 = 1995 4
	 -0010-09-15T04:44:23 = -10 3

       yQQQ (y QQQ)

	  2008-02-05T18:30:30 = 2008 Q1
	  1995-12-22T09:05:02 = 1995 Q4
	 -0010-09-15T04:44:23 = -10 Q3

       yyQ (Q yy)

	  2008-02-05T18:30:30 = 1 08
	  1995-12-22T09:05:02 = 4 95
	 -0010-09-15T04:44:23 = 3 -10

   Miscellaneous
       Prefers 24 hour time?

       Yes

       Local first day of the week

       Mosopulogo

SUPPORT

       See DateTime::Locale.

AUTHOR

       Dave Rolsky <autarch@urth.org>

COPYRIGHT

       Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the
       same terms as Perl itself.

       This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's
       license.

perl v5.18.2							    2017-10-06						   DateTime::Locale::tn(3)
All times are GMT -4. The time now is 09:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy