simple merge of CSV file

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP











up vote
0
down vote

favorite












I want to merge two CSV without any condition and no primary.It should be first row file1 and file2.



file1



id,name,city


file2



mobileno,address,email


output



id,name,city,mobileno,address,,email


can you please let me know how can i achive this output







share|improve this question


















  • 1




    Are we to assume that the double comma in the output is a typo?
    – Kusalananda
    Feb 16 at 12:14














up vote
0
down vote

favorite












I want to merge two CSV without any condition and no primary.It should be first row file1 and file2.



file1



id,name,city


file2



mobileno,address,email


output



id,name,city,mobileno,address,,email


can you please let me know how can i achive this output







share|improve this question


















  • 1




    Are we to assume that the double comma in the output is a typo?
    – Kusalananda
    Feb 16 at 12:14












up vote
0
down vote

favorite









up vote
0
down vote

favorite











I want to merge two CSV without any condition and no primary.It should be first row file1 and file2.



file1



id,name,city


file2



mobileno,address,email


output



id,name,city,mobileno,address,,email


can you please let me know how can i achive this output







share|improve this question














I want to merge two CSV without any condition and no primary.It should be first row file1 and file2.



file1



id,name,city


file2



mobileno,address,email


output



id,name,city,mobileno,address,,email


can you please let me know how can i achive this output









share|improve this question













share|improve this question




share|improve this question








edited Feb 16 at 12:13









Kusalananda

103k13202318




103k13202318










asked Feb 16 at 11:52









arunramalingam83

1




1







  • 1




    Are we to assume that the double comma in the output is a typo?
    – Kusalananda
    Feb 16 at 12:14












  • 1




    Are we to assume that the double comma in the output is a typo?
    – Kusalananda
    Feb 16 at 12:14







1




1




Are we to assume that the double comma in the output is a typo?
– Kusalananda
Feb 16 at 12:14




Are we to assume that the double comma in the output is a typo?
– Kusalananda
Feb 16 at 12:14










1 Answer
1






active

oldest

votes

















up vote
5
down vote













Use paste and set the delimiter to comma as opposed to tab with -d:



paste -d, file1 file2





share|improve this answer




















    Your Answer







    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "106"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    convertImagesToLinks: false,
    noModals: false,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );








     

    draft saved


    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f424588%2fsimple-merge-of-csv-file%23new-answer', 'question_page');

    );

    Post as a guest






























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes








    up vote
    5
    down vote













    Use paste and set the delimiter to comma as opposed to tab with -d:



    paste -d, file1 file2





    share|improve this answer
























      up vote
      5
      down vote













      Use paste and set the delimiter to comma as opposed to tab with -d:



      paste -d, file1 file2





      share|improve this answer






















        up vote
        5
        down vote










        up vote
        5
        down vote









        Use paste and set the delimiter to comma as opposed to tab with -d:



        paste -d, file1 file2





        share|improve this answer












        Use paste and set the delimiter to comma as opposed to tab with -d:



        paste -d, file1 file2






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Feb 16 at 12:07









        Raman Sailopal

        1,18317




        1,18317






















             

            draft saved


            draft discarded


























             


            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f424588%2fsimple-merge-of-csv-file%23new-answer', 'question_page');

            );

            Post as a guest













































































            Popular posts from this blog

            How to check contact read email or not when send email to Individual?

            Displaying single band from multi-band raster using QGIS

            How many registers does an x86_64 CPU actually have?