Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sed Question 1. (Don't quite know how to use sed! Thanks)
Top Forums Shell Programming and Scripting Sed Question 1. (Don't quite know how to use sed! Thanks) Post 302257277 by beibeiatNY on Tuesday 11th of November 2008 11:02:08 PM
Old 11-12-2008
Sed Question 1. (Don't quite know how to use sed! Thanks)
  1. Write a sed script to extract the year, rank, and stock for the most recent 10 years available in the file top10_mktval.csv, and output in the following format:



------------------------------
YEAR |RANK| STOCK
------------------------------
2007 | 1 | Exxon Mobil
2007 | 2 | Genl Electric
2007 | 3 | Microsoft Corp
2007 | 4 | AT&T Inc
2007 | 5 | Procter & Gamble
2007 | 6 | Google Inc'A'
2007 | 7 | Chevron Corp
2007 | 8 | Johnson & Johnson
2007 | 9 | Wal-Mart Stores
2007 | 10 | Bank of America
2006 | 1 | Exxon Mobil
...



Observe that:

  • Headers are added.
  • Rank is now the second field.
  • The last two fields in the original file are not printed.
  • The delimiters '|' are aligned.
You may assume that the records in this file are always in reverse chronological order, and there are always 10 entries (ranked 1-10) for each year.

top10_mktval.csv is in the attachment


Thank you !

top10_mktval.rar (3.1 KB) 
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Sed question

My data file look like tis field1:field2:field3:field4:field5 I wan to compare field 2 with 1 variable and if match change the details of it. How can i do it? I used to do it like tis: #in shell script checkSerial() { while do echo "  \c" ... (1 Reply)
Discussion started by: AkumaTay
1 Replies

2. UNIX for Dummies Questions & Answers

sed question

Hi, i'm in vi and am trying to globbaly changing some values. msisdn="4478....... for msisdn="078...... i've tried :s/msisdn="4478/msisdn="078/g but it complains it can't match the string. I'm thinking its the = and " thats the problem. Please help. HPUX 11i Cheers (3 Replies)
Discussion started by: nhatch
3 Replies

3. Shell Programming and Scripting

sed question

all, I am trying to use sed to read into a file and if a certain line exists (TRUSTHOSTKEY = YES), then I want to replace it with TRUSTHOSKEY = NO. My problem is that the line may exist as: trusthostkey=yes trusthostkey = yes TRUSTHOSTKEY = YES trusthostkey =yes It will however always... (1 Reply)
Discussion started by: hedrict
1 Replies

4. Shell Programming and Scripting

sed question

I'm wondering if you can do the following with sed or some other way. I would like to chang the character "*" in a string to "\052" inside of a script? i.e. string="text * text" #chang to string="text \052 text" (2 Replies)
Discussion started by: OldNo7
2 Replies

5. Shell Programming and Scripting

Use variable in sed don't work.

Hi all. I have a script as below: cutmth=`TZ=CST+2160 date +%b` export cutmth echo $cutmth >> date.log sed -n "/$cutmth/$p" alert_sbdev1.log > alert_summ.log My purpose is to run through the alert_sbdev1.log and find the 1st occurence of 'Jan' and send everything after that line to... (4 Replies)
Discussion started by: ahSher
4 Replies

6. Shell Programming and Scripting

Question on SED

Say for example I have a string as "/diggi/binary/d/e/f" I need the output as e ( The Second last “string”) . I want this using SED. Because using AWK its very easy. (4 Replies)
Discussion started by: Shell_Learner
4 Replies

7. Shell Programming and Scripting

grep? awk? sed? I don't know

Hi everyone! I have a file like this And I would like to find the Medium label when the value "last write" is "Jan 14" (it's could be another value like "jan 6") I really don't know what way to use to solve this problem... Thanks! (5 Replies)
Discussion started by: Castelior
5 Replies

8. UNIX for Dummies Questions & Answers

Using sed to change lines and add them if they don't exist..

I've googled the hell out of this, and in my quest to advance my knowledge and expertise in modifying phones to make them more awesome, I ended up here. I've found answers about patterns and whatnot that seem really complex for what I am trying to do, and basically it is this: if the line says... (2 Replies)
Discussion started by: Silentbtdeadly
2 Replies

9. UNIX for Beginners Questions & Answers

sed question

have some data and I'm attempting to manipulate with sed with not much success. Name John Davis Phone 5555555 Name Tim Watson Phone 1111111 would like to get that data to sort like this John Davis 5555555 Tim Watson 1111111 gotten sed to search for the value below 'Name'... (5 Replies)
Discussion started by: jimmyf
5 Replies

LEARN ABOUT DEBIAN

fntsample

fntsample(1)						      General Commands Manual						      fntsample(1)

NAME

       fntsample - PDF and PostScript font samples generator

SYNOPSIS

       fntsample [ OPTIONS ] -f FONT-FILE -o OUTPUT-FILE
       fntsample -h

DESCRIPTION

       fntsample  program  can	be  used  to generate font samples that show Unicode coverage of the font and are similar in appearance to Unicode
       charts. Samples can be saved into PDF (default) or PostScript file.

OPTIONS

       fntsample supports the following options.

       --font-file, -f FONT-FILE
	      Make samples of FONT-FILE.

       --font-index, -n IDX
	      Font index for FONT-FILE specified using --font-file option.  Useful for files that contain multiple fonts,  like  TrueType  Collec-
	      tions (.ttc).  By default font with index 0 is used.

       --output-file, -o OUTPUT-FILE
	      Write output to OUTPUT-FILE.

       --other-font-file, -d OTHER-FONT
	      Compare FONT-FILE with OTHER-FONT.  Glyphs added to FONT-FILE will be highlighted.

       --other-index, -m IDX
	      Font index for OTHER-FONT specified using --other-font-file option.

       --postscript-output, -s
	      Use PostScript format for output instead of PDF.

       --svg, -g
	      Use SVG format for output.  The generated document contains one page.  Use range selection options to specify which.

       --print-outline, -l
	      Print  document  outlines data to standard output.  This data can be used to add outlines (aka bookmarks) to resulting PDF file with
	      pdfoutline program.

       --include-range, -i RANGE
	      Show characters in RANGE.

       --exclude-range, -x RANGE
	      Do not show characters in RANGE.

       --style, -t "STYLE: VAL"
	      Set STYLE to value VAL.  Run fntsample with option --help to see list of styles and default values.

       --help, -h
	      Display help text and exit.

       Parameter RANGE for -i and -x can be given as one integer or a pair of integers delimited by minus sign (-).  Integers can be specified	in
       decimal,  hexadecimal  (0x...) or octal (0...) format.  One integer of a pair can be missing (-N can be used to specify all characters with
       codes less or equal to N, and N- for all characters with codes greather or equal to N).	Multiple -i and -x options can be used.

EXAMPLES

       Make PDF samples for font.ttf and write them to file samples.pdf:
	      fntsample -f font.ttf -o samples.pdf

       Make PDF samples for font.ttf, compare it with oldfont.ttf and highlight new glyphs. Write output to file samples.pdf:
	      fntsample -f font.ttf -d oldfont.ttf -o samples.pdf

       Make PostScript samples for font.ttf and write output to file samples.ps.  Show only glyphs for characters with	codes  less  or  equal	to
       U+04FF but exclude U+0370-U+03FF:
	      fntsample -f font.ttf -s -o samples.ps -i -0x04FF -x 0x0370-0x03FF

       Make PDF samples for font.ttf and save output to file samples.pdf adding outlines to it:
	      fntsample -f font.ttf -o temp.pdf -l > outlines.txt
	      pdfoutline temp.pdf outlines.txt samples.pdf

AUTHOR

       Copyright (C) 2007 Eugeniy Meshcheryakov <eugen@debian.org>
       Homepage: <http://fntsample.sourceforge.net/>

SEE ALSO

       pdfoutline(1)

								    2010-10-14							      fntsample(1)
All times are GMT -4. The time now is 07:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy