====== SED - Delete - Delete leading zeroes from selected double quoted fields ======

Strip leading zeros from fields 3 and 5 only.  There could be one or many leading zeroes.

<code bash>
"ACCOUNT","REAL","022000046977525","REAL","00000220000488","ONLINE",......
</code>

Desired output:

<code bash>
"ACCOUNT","REAL","22000046977525","REAL","220000488","ONLINE",......
</code>

----

<code bash>
sed -re '   s/","/\n/4;s//\n/2;   s/\n0*([0-9])/","\1/g' filename
</code>

<WRAP info>
**NOTE:**  Assumes that all the fields are quoted.

Marks the third and fifth fields by a newline and remove any leading zeros.

In cases where the entire field is zeros, it will preserve the last zero rather than make the field vanish.
</WRAP>


----

===== Using awk =====

<code bash>
awk -F, '{OFS=","; sub(/"0+/, "\"", $3); sub(/"0+/, "\"", $5)}1'
</code>

Shouldn't be an issue unless your header actually has leading zeros but if needed you could do:

<code bash>
awk -F, 'NR > 1{OFS=","; sub(/^"0+/, "\"", $3); sub(/^"0+/, "\"", $5)}1'
</code>

This will replace the " and all leading zeros in fields 3 and 5 with just a quote.