How to add fields to different file?

UNIX for Beginners Q & A
1

hi,
would you help me?
i have file total.csv

"name","id","gender"
 "a,"e23","f"
 "b,"34d","g"
 "c","45f","f"
 "d","45s","f"

and file count.csv

3

i want to add file count to file total every row

 name,id,gender,total_match
 "a,"e23","f","3"
 "b,"34d","g","3"
 "c","45f","f","3"
 "d","45s","f","3"
2

Hi kivale,
All of the usual questions apply to every thread you start...

  1. What operating system are you using?
  2. What shell are you using?
  3. What have you tried to solve this problem on your own?

And, in addition, for this thread:

  1. Where did the name "total_match" come from?
  2. Where did the double quotes around the data you are reading from count.csv ? Are there really supposed to be mismatched double-quotes in the first field in the second and third lines in total.csv ?
  3. Where is the updated file supposed to go?
4

dear R. Singh

thankyou for the reply

i try this but the result not like expectation.
this is the result

3,"""a,"e23","f"
5

Hello kivale,

I have deleted my post, please answer Don's questions first and show your attempts which you have put to solve this problem to us in code tags.

Thanks,
R. Singh

6

Please make sure your files don't contain DOS line termnators ( ^M = \r = 0x0D = <CR> ).