Have a file like the following:
10, X1'100', A, X1'200',C
20, X1'300',B, ,D
30, X1'400', X1'500',F,G
Want to revise it to
10, Y2'(100','CC'), A, Y2('200','CC'),C
20, Y2('300','CC'),B, ,D
30, Y2('400','CC'), Y2('500','CC'),F,G
That is to change any item like X1'100' to Y2('100','CC') with sed or awk,
Please, can any gurus shed some light on it?
Thanks in advance.