Shell Programming and Scripting

Hello
I would like to replace in a big file:

this
by this

As you see, the date into the second field is to be remove...
How can I do?
the patern could be this: and Thanks a lot

Code:

 awk -F, '{print $1 FS $3}' file

Code:

sed 's/,.*,/,/'

Hi
ok it works, but in some case I have the second filed with the title with comas...
So the sed sed 's/,.*,/,/'drop the rigth part of the title...
Exemple:

000000001 260 L $$aVIENNA :$$bIAEA, SECOND INFO, 1988,$$c1988.

Code:

sed 's/, [0-9]*,/,/'

Code:

sed 's/[^,]*,\([^,]*$\)$/\1/' infile

Code:

awk -F, '{$(NF-1)=x}sub(FS FS,FS)' OFS=, infile

Hi Aia
thanks for the exemple...
It still don't works for all the records. Look this exemple:
Where SAN DIEGO is the first field (no problem with it)
and where ACADEMIC PRESS, INC.;1989;SAN DIEGO, CALIFORNIA 92101
is the second filed...

If I pass your script I have this:

SAN DIEGO, CALIFORNIA 92101 is missing then...
Maybe there is a way to get just 4 digits as a date?
I try this but it do not works:

Thanks in advance if you have some idea.
Cheers