Search found 4 matches

by ws_systems
03 Nov 2013 19:16
Forum: DOS Batch Forum
Topic: Reading Data in a CSV, removing lines, and adding entries.
Replies: 7
Views: 4021

Re: Reading Data in a CSV, removing lines, and adding entrie

aGerman, My appologies. Im an Idiot. Both of your codes work flawless! I forgot and left my own merge.csv file that I had been working on. Essentially once your code hit that CSV in the folder it went nuts! Both of your work flawless! I am curious if you can explain which one is more efficient or wh...
by ws_systems
03 Nov 2013 19:01
Forum: DOS Batch Forum
Topic: Reading Data in a CSV, removing lines, and adding entries.
Replies: 7
Views: 4021

Re: Reading Data in a CSV, removing lines, and adding entrie

Some things I want to know: @echo off &setlocal set "folder=C:\wherever\your\CSVs\are" set "outfile=merge.csv" pushd "%folder%" >"%outfile%" type nul for /f "delims=" %%i in ('dir /a-d /b *.csv') do ( set "infile=%%i" setlocal enablede...
by ws_systems
03 Nov 2013 18:54
Forum: DOS Batch Forum
Topic: Reading Data in a CSV, removing lines, and adding entries.
Replies: 7
Views: 4021

Re: Reading Data in a CSV, removing lines, and adding entrie

Some things I want to know: - What's the maximum length of the rows? - Do you know what characters are used for the line breaks? (Hopefully you could check using a HEX editor) - Are all the files in the same directory? - Should the results be written back to the files or should they be merged in a ...
by ws_systems
03 Nov 2013 17:57
Forum: DOS Batch Forum
Topic: Reading Data in a CSV, removing lines, and adding entries.
Replies: 7
Views: 4021

Reading Data in a CSV, removing lines, and adding entries.

Long time reader! Some of the smartest guys on the web are her on dostips.com so hopefully someone skilled can help me out! Tried coding this and gave up. Figured start fresh. Scenario: Every night my system downloads about 200 csv files. Recently, the format of them has changed. Now appended to eve...