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 …
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 …
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 …
Please check the website for instructions and leave a reply if you have any specific question https://www.gisci.org/
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 …
Certified Floodplain Manager (CFM) preparation Guide This is something I highly recommend to look at before preparing the CFM exam. IOWA STATE UNIVERSITY provides free classes for flooding and the national flood insurance programs. These are short videos covers most basic aspects of NFIP Click each tab below to go …
This video shows how to use excel to do auto fill
You can use sparklines to show trends in a series of values. This video demos how to create sparklines, adjust axis, change color and change sparkline type.
This video demos how to use excel countifs and sumifs to perform summary based on multiple conditions
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 …
