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 SUSE

ooconvert

ooconvert(1)							   User Commands						      ooconvert(1)

Name
       ooconvert - Commandline Document Converter Using OpenOffice.org

SYNOPSIS

       ooconvert [--help] [--force]  input output

DESCRIPTION

       This  tool  converts documents between various formats on the commandline.  It uses OpenOffice.org that guarantees the quality of available
       import and export filters.

       This tool tries to start OpenOffice.org in the server mode on backgroud.  It does not work if the OpenOffice.org  application  has  already
       been running. Also it slows down the conversion a lot. We hope to reduce these limitations in the further versions.

OPTIONS

       input  Input file. The filename suffix must be one of the currently supported file formats, see below.

       output Output  file. The filename suffix defines the output file format. It must be one from the table below. An existing file can be over-
	      written by the --force option.

       --help Print help and exit.

       --force
	      Force an already existing output file to be replaced.

SUPPORTED FILE FORMATS

       The current version of this tool does not read the list of available input and output filters directly from  OpenOffice.org.  The  list	of
       supported file formats is hardcoded and thus limited to:

       doc    Microsoft Word 97/2000/XP

       docx   MS Word 2007 XML

       dot    Microsoft Word 97/2000/XP Template

       dotx   MS Word 2007 XML Template

       html   HyperText Markup Language (Web Page)

       odt    ODF Text Document

       ods    ODF Spreadsheet

       odp    ODF Presentation

       ott    ODF Text Document Template

       ots    ODF Spreadsheet Template

       otp    ODF Presentation Template

       pdf    Portable Document Format

       ppt    Microsoft PowerPoint 97/2000/XP

       pptx   Microsoft PowerPoint 2007 XML

       pot    Microsoft PowerPoint 97/2000/XP Template

       potx   Microsoft PowerPoint 2007 XML Template

       rtf    Rich Text Format

       stc    OpenOffice.org 1.0 Spreadsheet Template

       sti    OpenOffice.org 1.0 Presentation Template

       stw    OpenOffice.org 1.0 Text Document Template

       sxc    OpenOffice.org 1.0 Spreadsheet

       sxi    OpenOffice.org 1.0 Presentation

       sxw    OpenOffice.org 1.0 Text Document

       swf    Macromedia Flash

       txt    Plain Text

       xls    Microsoft Excel 97/2000/XP

       xlsx   Microsoft Excel 2007 XML

       xlt    Microsoft Excel 97/2000/XP Template

       xltx   Microsoft Excel 2007 XML Template

TROUBLESHOOTING PROBLEMS

       See http://en.opensuse.org/Bugs:OOo for more details about how to report bugs in OpenOffice.org.

AUTHOR

       This manual page was created by Petr Mladek <petr.mladek@novell.com>.

OpenOffice.org Converter					    2009-02-09							      ooconvert(1)
All times are GMT -4. The time now is 04:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy