Solaris

Hi all,

I have file having 4 coulmn like

9246309198,406655682,400009246309198
9246309198,9246309198,400009246309198
9246309198,9246309198,400009246309198
9246309198,9246309198,400009246309198
9246309198,406655682,400009246309198
9246309198,9246309198,400009246309198

I want to valid the 2nd column if the length of the 2nd column is 9 digit i want add astring X beginning of the 2nd column.Which will give me the Output like.


9246309198,X406655682,400009246309198
9246309198,9246309198,400009246309198
9246309198,9246309198,400009246309198
9246309198,9246309198,400009246309198
9246309198,X406655682,400009246309198
9246309198,9246309198,400009246309198

Dears Is it possible?.

hi Salathi,

hope this will work for u,

awk -F, '{ if (length($2) == 9) {print $1",""X"$2","$3;} else { print $0}}' filename

Code:

sed -e "s/^\([^,]*,\)\([0-9]\{9\}\),/\1X\2,/g" input.txt

or

Code:

sed -e "s/^\([^,]*,\)\([^,]\{9\}\),/\1X\2,/g"

Dears,
Both the codes worked for me.

Thanks a ton.
Vino,
I am able to understand the awk syntax.
Can u please explain the sed code.

sed -e "s/^\([^,]*,\)\([^,]\{9\}\),/\1X\2,/g"

^ - start at the beginning of each line
^\([^,]*,\) - collect that part of the string which starts from the beginning upto the place where you encounter the first comma and place it in buffer1

\([^,]\{9\}\) - Then collect any non-comma set of characters who length is 9 and then followed by a comma and then place it in buffer2

\1X\2, - dump the contents of buffer1 followed by a X followed by the contents of buffer2 followed by a comma.