Combine files into a CSV

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.

Réponses (1)

Sean de Wolski
Sean de Wolski le 14 Jan 2015

0 votes

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 commentaires

Ian
Ian le 14 Jan 2015
thanks will try it out
Ian
Ian le 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
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

Cette question est clôturée.

Tags

Question posée :

Ian
le 14 Jan 2015

Clôturé :

le 20 Août 2021

Community Treasure Hunt

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

Start Hunting!

Translated by