Shell Programming and Scripting

All,
I have a text file which has the following data
X_SQL_13,X_SQL_14,X_SQL_15,X_SQL_16,X_SQL_17,X_SQL_18,X_SQL_19,X_SQL_20,X_SQL_21,X_SQL_22,X_SQL_23,X _SQL_24,X_SQL_25,X_SQL_26,X_SQL_27,
X_SQL_28,X_SQL_29,X_SQL_30,C_TYPE_GNRT,F_TRACE_SQL,X_PARAM_1,X_PARAM_2,X_PARAM_3,X_PARAM_4,X_PARAM_5 ,X_MSG_PARAM_1,X_MSG_PARAM_2,
X_MSG_PARAM_3,X_MSG_PARAM_4,X_MSG_PARAM_5,C_TYPE_SQL) values ('ECP','TVP404100','select * from (select
(D_PROC) D_PROC
,ORG,LOGO
,REC_NBR
,R SEQ,decode ( r,1 ,MESSAGE_LINE_1,
2 ,MESSAGE_LINE_2,
3 ,MESSAGE_LINE_3,
4 ,MESSAGE_LINE_4,
5 ,MESSAGE_LINE_5,
6 ,MESSAGE_LINE_6,
7 ,MESSAGE_LINE_7,
8 ,MESSAGE_LINE_8,
9 ,MESSAGE_LINE_9,
10 ,MESSAGE_LINE_10,
11 ,MESSAGE_LINE_11,
12 ,MESSAGE_LINE_12,
13 ,MESSAGE_LINE_13,
14 ,MESSAGE_LINE_14,
15 ,MESSAGE_LINE_15,
16 ,MESSAGE_LINE_16,
........................
......................


Can any one please tell me how to relace MESSAGE_LINE_1 to MESSAGE_LINE_16 with MESSAGE_LINE_1_1 to MESSAGE_LINE_16_1

I was using :%s/MESSAGE_LINE_16/MESSAGE_LINE_16_1/ in the VI editor
But I want something as as

:%s/MESSAGE_LINE_*/MESSAGE_LINE_*_1/

thanks

please delete this

Code:

:%s/,$/_1,/g

With sed...

Code:

 
sed 's/\(MESSAGE_LINE_[0-9].*\)\(,.*\)/\1_1\2/g' infile

Code:

:g/MESSAGE_LINE/s/_\([0-9]*\),/_\1_1,/