I have input file that is having below text

098769
178902
234678

I want to modify the input file like below.

'098769',
'178902',
'234678'

Can you please help to get this. I tried but i am not getting this.

If you don't want to use awk:
sed -e"s/^/'/;s/$/',/" -e'$s/,//' input_file

awk -v Q=\' 'NR==1{Save0=$0; next}
{ print Q Save0 Q ","; # lag one line so that last line is different
Save0=$0 # store this for next print command
}
END{ print Q Save0 Q }' # at end - dont print the comma

Thank You Shell Life,

It worked for me. Apprreciate your immediate reply

Thanks Awk for your immediate reply, i did not understand how it will be
working. As i am learning, where should i give the input file or i should
store this as one program and invoke separately. Can you please explain

Thanks in Advance