Search Results

awesome...thank you guys so much. you are a lifesaver.

this worked great however it only grab the 2nd field on the 2nd file. How do I get it so that I get everything on the 2nd file if it matches the 1st field of the first file. The 2nd file has 6 field...

I tried that however it will only grab the first match. For example that I just gave you, it will only grab the first 2 line.

1692 @00000000201@00000205@20090402@000015000@RONALD F. SZOPA, DMD
...

sorry, output would look like this:

File 1:

1692 @00000000201@00000205@20090402@000015000
1692 @00000000202@00000206@20090402@000010000...

Hello. I have 2 files.

File 1:

1692 @00000000201@00000205@20090402@000015000
1692 @00000000202@00000206@20090402@000010000
263157760@00000000401@00000201@20090402@000056250...

any help thanks

when I do this code, "awk -F, '{printf "%s,%s,%09.2f,%s,%s\n",$1,$2,$3,$4,$5}' filename"

it actually does output to something I can use however it duplicate it. Example.

File A:

abc1, defg,...

i tried

awk -F"," '{
if(_[$1]==0){
_[$1]=1
print $0
}
}' a > t1


with file a and outputting it to t1 however it doesn't do anything. The...

I tried that code however it doesn't work...can someone please help me out. Thank you

any help on explaining the code for me. Thank you

would you be so kind to explain the code a bit for me. Thank you for your help.

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
...

by the way, the final file would be something like this:

abc1, defg, 000050.00, mno ,990, airplanes, runway,doctor
abc2, cats, 000100.00, pops ,991, jets,birds, much
abc3, dogs, 000001.00,...

hello everyone. I'm hoping someone can help me out here. I have 2 files. It looks like this:

File 1:

abc1, defg, 50.00, mno,990
abc2, cats, 100.00, pops,991
abc3, dogs, ...