When you show us a command that you've used to try to get something to work, we generally expect to see a command name somewhere. All that you showed us is a something that might be an ed, ex, or sed substitute command. Obviously, a shell can't interpret an editor substitute command without knowing what utility you want to use to interpret that command.

I generally find awk easier to work with when I'm dealing with a varying number of fields and there is no reason to believe that the same fields in all lines will meet the same criteria. I'm also not sure why you bothered to show us a file header when it doesn't appear anywhere in your sample input files nor in your desired output. But, if one had a file named file that contained:

Code:

ID_WVR,SAK_WVR_SVC,DSC_WVR_WVC,SAK_PROCEDURE,CODES,CDE_PROC_MOD ,CDE_PROC_MOD_2 ,CDE_PROC_MOD_3
AMR,5100,Total Services,305,D0120,,,
AMR,5101,Periodic Services,40702,H2011,U1,,
AMR,5112,Day Services,30616,T2020,U1,HQ,
AMR,5112,Day Services,30616,T2020,U6,UA,In home day services moved under day services on 3/30/15
AMR,5378,Supported Services,40876,T2032,U1,REMOVE,Max rate sheet: end dated 2006

and one had a script similar to:

Code:

#!/bin/ksh
awk -v sq="'" '
BEGIN {	FS = OFS = ","
}
{	for(i = 1; i <= NF; i++)
		printf("%s%s", ($i ~ /^[0-9]*$/) ? $i : sq $i sq,
		    (i == NF) ? ORS : OFS)
}' file

one might get output similar to:

Code:

'ID_WVR','SAK_WVR_SVC','DSC_WVR_WVC','SAK_PROCEDURE','CODES','CDE_PROC_MOD ','CDE_PROC_MOD_2 ','CDE_PROC_MOD_3'
'AMR',5100,'Total Services',305,'D0120',,,
'AMR',5101,'Periodic Services',40702,'H2011','U1',,
'AMR',5112,'Day Services',30616,'T2020','U1','HQ',
'AMR',5112,'Day Services',30616,'T2020','U6','UA','In home day services moved under day services on 3/30/15'
'AMR',5378,'Supported Services',40876,'T2032','U1','REMOVE','Max rate sheet: end dated 2006'

if one ran that script in the directory containing that file.

Is that what you were trying to do?

And, of course, since you didn't bother telling us what operating system and shell you're using, one should note that if you want to try this on a Solaris/SunOS system, you'll need to change awk in that script to /usr/xpg4/bin/awk or nawk. This was tested using a Korn shell, but should work with any shell that is based on Bourne shell syntax. (Who knows, it might even work with csh or one of its derivatives.)