Sponsored Content
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 !

 

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
mimecheck(1)						      Check MIME attachments						      mimecheck(1)

NAME
mimecheck - determine the type of the MIME encoded of an attachment mimezip - detect the type of MIME encoded zip archive in an attachment mimebzip - detect the type of MIME encoded bzip2 data in an attachment mimegzip - detect the type of MIME encoded gzip data in an attachment SYNOPSIS
mimecheck boundary [file] mimezip boundary [file] mimebzip boundary [file] mimegzip boundary [file] DESCRIPTION
The scripts mimecheck, mimezip, mimebzip, and mimegzip can be used to determine the contents of MIME encoded attachments of the type appli- cation/octet-stream. The scripts require the boundary as provided in the headers and/or bodys of mails with enclosed attachments. The scripts read from standard input if no file was provided and write out the detected MIME type to standard out. EXAMPLE
A short filter rule used by procmail(1) to check for DOS executables in MIME encoded zip archives found in many attachments: BLANK="[ ]+" TYPE="${BLANK}multipart/(alternative|mixed)" :0 * $ ^Content-Type:${TYPE};(${BLANK}|$)*boundary=["']?[^ "';]+ { BOUNDARY="${MATCH}" TYPE="" :0 B * $ ^Content-Transfer-Encoding:${BLANK}base64 { TYPE=`mimecheck ${BOUNDARY}` :0 * TYPE ?? application/x-zip { TYPE=`mimezip ${BOUNDARY}` } } :0 * TYPE ?? executable.*DOS * TYPE ?? DOS.*executable /dev/null } there is no guarantee that this piece of a procmailrc(5) file will work. SEE ALSO
procmailrc(5), file(1), sed(1), mimencode(1). COPYRIGHT
2007 SuSE LINUX Products GmbH, Nuernberg, Germany, 2007 Werner Fink. AUTHORS
Werner Fink <werner@suse.de>. 3rd Berkeley Distribution Juni 28, 2007 mimecheck(1)
All times are GMT -4. The time now is 01:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy