• Is there any simple way to do this?

    From Lu Wei@21:1/5 to All on Thu Sep 7 18:14:44 2023
    XPost: microsoft.public.windowsxp.general

    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?

    --
    Regards,
    Lu Wei
    IM: xmpp:[email protected]
    PGP: 0xA12FEF7592CCE1EA

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From R.Wieser@21:1/5 to All on Thu Sep 7 12:57:03 2023
    XPost: microsoft.public.windowsxp.general

    Lu Wei,

    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?

    Using VBScript you could read (and discard) the first line(s) using ".readline", which you can than follow-up with a ".readall".

    Regards,
    Rudy Wieser

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lu Wei@21:1/5 to R.Wieser on Wed Sep 13 14:10:50 2023
    XPost: microsoft.public.windowsxp.general

    On 2023-9-7 18:57, R.Wieser wrote:
    Lu Wei,

    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?

    Using VBScript you could read (and discard) the first line(s) using ".readline", which you can than follow-up with a ".readall".


    Thank you. Now it works after I had some struggle with weird results of
    UTF format inconsistency.


    --
    Regards,
    Lu Wei
    IM: xmpp:[email protected]
    PGP: 0xA12FEF7592CCE1EA

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