code_junkie

Combining values from different files into one CSV file

Nov 10th, 2011
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. file1: file2: file3:
  2. 1 a A
  3. 2 b B
  4. 3 c C
  5.  
  6. ~$ paste file{1,2,3} |sed 's/^|$/"/g; s/t/","/g'
  7. "1","a","A"
  8. "2","b","B"
  9. "3","c","C"
  10.  
  11. file1: file2: file3:
  12. 1 a A
  13. 2 b B
  14. 3 c C
  15.  
  16. ~$ paste file{1,2,3} |sed 's/^|$/"/g; s/t/","/g'
  17. "1","a","A"
  18. "2","b","B"
  19. "3","c","C"
  20.  
  21. file1: file2: file3:
  22. 1 a A
  23. 2 b B
  24. 3 c C
  25.  
  26. ~$ paste file{1,2,3} |sed 's/^|$/"/g; s/t/","/g'
  27. "1","a","A"
  28. "2","b","B"
  29. "3","c","C"
  30.  
  31. file1: file2: file3:
  32. 1 a A
  33. 2 b B
  34. 3 c C
  35.  
  36. ~$ paste file{1,2,3} |sed 's/^|$/"/g; s/t/","/g'
  37. "1","a","A"
  38. "2","b","B"
  39. "3","c","C"
  40.  
  41. ~$ paste --delimiter , file{1,2,3}
  42. 1,a,A
  43. 2,b,B
  44. 3,c,C
  45.  
  46. cat filetwo >> fileone
Add Comment
Please, Sign In to add comment