Help using SED command Post: 302362182

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Help using SED command Post 302362182 by sh_kk on Thursday 15th of October 2009 07:41:02 AM

10-15-2009

Registered User

Help using SED command

Hi All,

I have converted a HTML page<http://www.imdb.com/chart/top> which consisted of the movie names using a pipelined SED commands to retrieve only the table as shown in the page.

Here is the o/p so far I have got
.......
|22.|8.7|The Usual Suspects|(1995)|239,740|
|23.|8.7|Psycho|(1960)|126,928|
|24.|8.6|The Silence of the Lambs|(1991)|217,130|
|25.|8.6|Sunset Blvd.|(1950)|47,585|
|26.|8.6|The Matrix|(1999)|338,524|
|27.|8.6|Memento|(2000)|238,630|
|28.|8.6|Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb|(1964)|141,831|
........

----------------------------------------------------------------

As can be seen, the o/p shows how the table of movies look on the HTML page.

My query is how to remove the trailing '.' in the first field i.e. rank field of the o/p.

So the expected o/p is :

|22|8.7|The Usual Suspects|(1995)|239,740|
|23|8.7|Psycho|(1960)|126,928|
|24|8.6|The Silence of the Lambs|(1991)|217,130|
|25|8.6|Sunset Blvd.|(1950)|47,585|
|26|8.6|The Matrix|(1999)|338,524|
|27|8.6|Memento|(2000)|238,630|
|28|8.6|Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb|(1964)|141,831|

Please remember,
1> The command should remove the trailing dot of the 1st field ONLY.
2 > The rank field ranges from 1 to 250 in value.

Please help me out on this one.

Thanks,
sh_kk

sh_kk

View Public Profile for sh_kk

Find all posts by sh_kk

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Sorry for the duplicate thread this one is similar to the one in https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121 Since there were no responses on the parent thread since it got resolved partially i thought to open the new...

2. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

Okay, title is kind of confusion, but basically, I have a lot of scripts on a server that I need to replace a ps command, however, the new ps command I'm trying to replace the current one with pipes to sed at one point. So now I am attempting to create another script that replaces that line. ...

3. UNIX for Dummies Questions & Answers

some help with the sed command please

hi all, attached you can find a small txt file ( .txt ), GIVEN that past_scheduler="islip" and scheduler="mucf" can somebody please tell me WHY sed 's/-u '$past_scheduler'/-u '$scheduler'/g' .txt > .txt.temp fails ? thanx

4. Shell Programming and Scripting

Convert Sed command to perl command

Hello, Can any perl experts help me convert my sed string to perl. I am unsuccessful with this. I have to remove this string from html files OAS_AD('Top'); I have come up with this. However the requirement is in perl. for find in $(find . -type f -name "file1.html") ; do cat $find |...

5. UNIX for Dummies Questions & Answers

sed insert command and variable expansion/command substitution

I know this script is crummy, but I was just messing around.. how do I get sed's insert command to allow variable expansion to show the filename? #!/bin/bash filename=`echo $0` /usr/bin/sed '/#include/ { i\ the filename is `$filename` }' $1 exit 0

6. UNIX for Advanced & Expert Users

sed command

Hi..... I'm using sed command for replace the words in a file cat >test.txt My test.txt contains Mary had a little ham Mary fried a lot of spam Jack ate a Spam sandwich Jill had a lamb spamwich Marry had a spicy wich $ sed 's/wich$/mirchi/g' test.txt output is: Mary had a little ham...

7. Shell Programming and Scripting

sed returns error "sed: -e expression #1, char 18: unterminated `s' command"

Hello All, I have something like below LDC100/rel/prod/libinactrl.a LAA2000/rel/prod/libinactrl.a I want to remove till first forward slash that is outputshould be as below rel/prod/libinactrl.a rel/prod/libinactrl.a How can I do that ???

8. Shell Programming and Scripting

sed Command

Hello, I'm working with this command which I'm having trouble understanding it: sed -e '1,$ s/SUB/N/g' < $1 > file.txt Where SUB stand for an special character with code in ASCII is 0x1A, notepad read it as a right arrow. Any help will be appreciated.

9. Shell Programming and Scripting

sed and awk giving error ./sample.sh: line 13: sed: command not found

Hi, I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :- ./sample.sh: line...

10. UNIX for Dummies Questions & Answers

Output of sed command to another sed command

Hi All, I'm relatively new to Unix scripting and am trying to get my head around piping. I'm trying to take a header record from one file and prepend it to another file. I've done this by creating several temp files but i'm wondering if there is a cleaner way to do this. I'm thinking...

LEARN ABOUT DEBIAN

aeustate

aeustate(5)							File Formats Manual						       aeustate(5)

NAME

	aeustate - aegis user state file

SYNOPSIS

	/var/lib/aegis/user/user-name

DESCRIPTION

	A user state file is used to store information about a user.  These file are created and maintained by aegis.  These file should not be
	edited by humans.

CONTENTS

	own = [{ ... }];
		This field is a list of change the user is currently working on, within project.  The changes are in either the being_developed or
		being_integrated state.  The structure of this field is as follows:

		project = string;
			The name of a project.

		change = [integer];
			The changes this user is working on in the project.

SEE ALSO

	aegis(5)
		aegis file format syntax

COPYRIGHT

	aegis version 4.24.3.D001
	Copyright (C) 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010 Peter
	Miller

	The aegis program comes with ABSOLUTELY NO WARRANTY; for details use the 'aegis -VERSion License' command.  This is free software and you
	are welcome to redistribute it under certain conditions; for details use the 'aegis -VERSion License' command.

AUTHOR

	Peter Miller   E-Mail:	 millerp@canb.auug.org.au
	//*		  WWW:	 http://www.canb.auug.org.au/~millerp/

Reference Manual						       Aegis							       aeustate(5)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Discussion started by: rajan_san

2. Shell Programming and Scripting

Loop with sed command to replace line with sed command in it

Discussion started by: cbo0485

3. UNIX for Dummies Questions & Answers

some help with the sed command please

Discussion started by: OneDreamCloser

4. Shell Programming and Scripting

Convert Sed command to perl command

Discussion started by: abacus