Info

This question is closed. Reopen it to edit or answer.

Combine files into a CSV

2 views (last 30 days)
Ian
Ian on 14 Jan 2015
Closed: MATLAB Answer Bot on 20 Aug 2021
I need to combine 3 files into a CSV, the 3 files do not contain the same number of rows there are also ASCII in the 3 files. Below is an example of the 3 files:
File 1
Apple,1
Orange,3
Banana,4
File 2
Orange,10
Banana,7
File 3 Banana,20
Output
Apple,1,Orange,10,Banana,20
Orange,3,Banana,7
Banana,4
Please advice and Thank you.

Answers (1)

Sean de Wolski
Sean de Wolski on 14 Jan 2015
doc dir
doc fopen
doc fgetl
doc fprintf
doc fclose
Use dir to find the three files to read. Fopen the files for reading and a new file for writing. Loop over each line in the reading files with fgetl, fprintfing the read to the new file. clean up at the end.
  3 Comments
Ian
Ian on 14 Jan 2015
I am sorry, I dint check the preview outcome. Had to press double enter for a new line please advice again thanks
Sean de Wolski
Sean de Wolski on 14 Jan 2015
There's nothing to change, the steps are the same...
Also, you can doubly indent a line to force new line
Hello (two spaced before H)
world

This question is closed.

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!