sed help please

Shell Programming and Scripting
1

Hello,
i need some help cause of wrong sql export.

i have

INSERT INTO table
(row0,row1,row2,row3,row4,row5,row6)
VALUES
(6655,35,88,654723456287654,237178985434723,812,734654323465424)
/
INSERT INTO table
(row0,row1,row2,row3,row4,row5,row6)
VALUES
(6533,76,87,234513,64433326,7,64,3)

As you see, sometimes there are 8 values instead of 7. So i need to replace the last "," with "." if there are 8 values, to get:

INSERT INTO table
(row0,row1,row2,row3,row4,row5,row6)
VALUES
(6655,35,88,654723456287654,237178985434723,812,734654323465424)
/
INSERT INTO table
(row0,row1,row2,row3,row4,row5,row6)
VALUES
(6533,76,87,234513,64433326,7,64.3)

Can't understand how to do this with sed or awk :\
thx for helping.:b:

2

Hi, lethearmy:

The following sed will change the 7th comma of a line to a period. If the only lines in your data with 7 commas are the ones that need editing, then this should be enough. Test carefully to make certain there are no unwanted sideeffects.

sed 's/,/./7'

Regards,
Alister

3

damn, that was quite simple, while i was searching for something much harder =\
Thanks a lot for a quick reply.