1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.WINDOWSX

  • Re: Is there any simple way to do this?

    From gfretwell@aol.com@21:1/5 to Lu Wei on Fri Sep 8 15:24:41 2023
    On Thu, 7 Sep 2023 18:14:44 +0800, Lu Wei <luweitest@gmail.com> wrote:

    I have a bunch of big CSV(comma separated value text) files that should
    be joined. I can't use the simple copy command like:
    copy 1.csv+2.csv result.csv
    because every csv file has a header line. The correct joining should
    keep only one header line.

    Is it possible to do this by a command or batch file? JSrcipt or
    VBScript is also fine, yet it seems all lines will be processed, which
    would be slow. Is there an efficient way to remove the first line only?

    I imagine Excel would do it if the fields are compatible. Append each
    new one to the accumulated file and then export as a CSV

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)