Batch change .txt to .csv

Please copy the following into the notepad, change the suffix to .bat @echo off setlocal enabledelayedexpansion for %%F in (*.txt) do ( set /p .=Processing [%%~F] … <nul set “firstline=” (for /f “tokens=* usebackq” %%a in (“%%~nxF”) do ( if not defined firstline ( set firstline=%%a echo !firstline:”=! ) else …

Batch merge csv

Please copy the following into the notepad, change the suffix to .bat for /f %%a in (‘dir /b *.CSV’) do for /f “tokens=*” %%b in (%%a) do echo %%b,%%a >> all.csv Place it in your folder, together with all other .csv file. Double click .bat file, it will generate the …

Professional Engineer (PE) Environmental Engineering

My strategy is to browse the reference manual quickly at first, so that i know where is everything and what they are generally talking about (you do not need to understand everything). Then I use the environmental engineering questions and solutions book, look at the question and look at the …

ESRI Desktop Associate

ESRI Desktop Associate 10.3 Preparation Guide Be sure to take the free samples questions from ESRI before going to exam http://training.esri.com/gateway/index.cfm?fa=catalog.webCourseDetail&courseid=2202 Esri ArcGIS Desktop Associate Certification Study Guide covers most of the topics (except for ArcGIS Pro and ArcGIS Online) http://www.amazon.com/ArcGIS-Desktop-Associate-Certification-Study/dp/1589483510 Be sure to familiar with the following topics The …

CSV  Splitter

CSV  Splitter – http://www.fxfisherman.com/forums/forex-metatrader/tools-utilities/75-csv-splitter-divide-large-csv-files.html.  Google earth can only deal with 2400 points.  If you are going to have more than that, you need this tool.  Sydney had ~90,000 water meters in Florida. HINT:  A bunch of addresses might get kicked out.  If you see a pattern of mistakes, fix them …