UNIX for Dummies Questions & Answers

^^

Sir, here is my pipelined SED so far to convert the HTML page to the o/p mentioned in Post 1.

sed '/Top 250 movies/!d' top250.html | sed 's/^.*<\/b><\/font><\/td><\/tr>//' | sed 's/<\/table>.*$//' | sed 's/<\/tr>$//' | sed 's/<\/tr>/#/g' | sed 's/<[^>]*>/ /g' | sed 's/ \{2,\}/|/g' | sed 's/.|/|/' -i | cat

I am not sure of -i option and its giving me the following error:

sed: no input files


What changes need to done to this?

---------- Post updated at 08:18 AM ---------- Previous update was at 08:12 AM ----------


I am not sure Sir. But

sed 's/.|/|/' file - > is changing only the 1st occurence.

WHen I change this command to sed 's/.|/|/g' , I get the following o/p


|1|9.|The Shawshank Redemptio|(1994|447,83|


As noticed, the 1st character of all the fields go missing

I really don't understand the problem.

Is the output in my last post not the desired output?

Sir, it was only changing the 1st occurrence of the rank field.

i.e. was getting |1|9.1| ... but then the next values continued to be the same
i.e. |2.|9.1| ....

I made the following change and now its working fine

sed 's/\.|/|/'


Thanks a lot everyone !!

---------- Post updated at 03:14 PM ---------- Previous update was at 08:36 AM ----------

How to use grep to retrieve a particular column.

Like for the following intermediate o/p:

29|8.6|North by Northwest|1959|83372
30|8.6|Se7en|1995|244038
31|8.6|Its a Wonderful Life|1946|90888
32|8.6|The Lord of the Rings: The Two Towers|2002|292149
33|8.6|Citizen Kane|1941|126588


the 1st column is the rank of movie, 2nd is the rating and 3rd is the Movie name.

I need to retrieve the 3rd column using grep and count no. of words in the movie name.

How to go about this?

---------- Post updated at 07:38 PM ---------- Previous update was at 03:14 PM ----------

Hiii... Can anyone please help out?

Bumping up posts or double posting is not permitted in these forums.

Please read the rules, which you agreed to when you registered, if you have not already done so.

You may receive an infraction for this. If so, don't worry, just try to follow the rules more carefully. The infraction will expire in the near future

Thank You.

The UNIX and Linux Forums.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Try this:

Code:

awk -F"|" '/Lord of the Rings/{print split($3,a," ")}' file

@sh_kk:


To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, avoid adding color or different fonts and font size to your posts. Selective use of color to highlight a single word or phrase can be useful at times, but using color, in general, makes the forums harder to read, especially bright colors like red.

Third, be careful when you cut-and-paste, edit any odd characters and make sure all links are working property.

Thank You.

The UNIX and Linux Forums

with bash

Code:

while IFS="|" read -r a b c
do
    echo "$a|${b%*.}|$c"
done < "file"