Quote:
Originally Posted by summer_cherry
Hi, hope below can help you.
But really do not know how many leading '0' you are expecting.
Code:
awk -F"," '{
if(_[$1]==0){
_[$1]=1
print $0
}
}' a > t1
join -t"," -11 -25 t1 b
|
thank you for the response so far. The field will be 9 digit. So it will vary on how many zero are place. Trying to make it look like this:
000000000
000000100
000000090
000001100
000012000
The last 2 digit represent the cents. Example 5.50 will be 000000550
