Adding reference number to field in CSV file 2

[ianicr]

Is there a way to add a ref no to a csv file in a certain field with awk? I need to add 0000000003 to field 6 then 0000000010 to the next, then 0000000017 to the next etc.
Thanks

 

[aigles]

Give us an example of input and output file please.

Jean Pierre.

 

[ianicr]

Input file:
"Mr","T","Smith","1 New Street","Birmingham",""
"Mr","R","Smith","3 New Street","Birmingham",""

Output File
"Mr","T","Smith","1 New Street","Birmingham","00000000003"
"Mr","R","Smith","3 New Street","Birmingham","00000000010"

It doesn't really matter about the leading zeros but that would be nice! Doesn't really matter about the quotes either as I can tr them out.

 

[PHV]

Try something like ths:

awk -F, 'BEGIN{i=3}
$7=="\"\""{$7=sprintf("%010d",i);i+=7}
{print}
' /path/to/input >output

Hope This Help
PH.

 

[aigles]

On my aix box, the output field separator is not affected by the -F option, I must add the statement : OFS=","

awk -F, 'BEGIN{OFS="," ;i=3}
$6=="\"\""{$6=sprintf("%010d",i);i+=7}
{print}
' /path/to/input >output

Jean Pierre.

 

[PHV]

Good catch Jean-Pierre, for the OFS issue and the $6.
ianicr, sorry for the typo.

 

[ianicr]

Thanks to both of you. That worked great!