Search found 4 matches
- 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...
- 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...
- 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 ...
- 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...