anchor.diff:  cat ./xls/pessoarenda*.csv.csv &gt; PessoaRenda.csv
   cat ./xls/responsavel01*.csv.csv &gt; Responsavel01.csv
   cat ./xls/responsavel02*.csv.csv &gt; Responsavel02.csv
  -cat ./xls/responsavelrenda*.csv.csv &gt; ResponsavelRenda.csv`</p>
  +cat ./xls/responsavelrenda*.csv.csv &gt; ResponsavelRenda.csv</pre>
  +</div>
   </div>
   <div class="paragraph">
   <p>Basta colocar todos os arquivos ZIP numa pasta juntamente com esse script e executar.
  
positive.code: <div class="paragraph">
  <p>E o script:</p>
  </div>
  <div class="paragraph">
  <p>`#!/bin/sh</p>
  </div>
  <div class="paragraph">
  <p>mkdir xls
  for i in $(ls *.zip)
  do
  unzip -j $i -x *.csv *.pdf -d xls
  done
  cd xls
  unoconv -i 59,34,UTF-8 -f csv *
  cd ..</p>
  </div>
  <div class="paragraph">
  <p>for i in $(ls ./xls/*.csv | grep -v Basico)
  doDadosCenso2010
  lc=<code>echo $i | tr '[A-Z]' '[a-z]'</code>
  sed '1d' $i | sed 's/,/./g' | sed 's/X//g' &gt; $lc.csv
  done</p>
  </div>
  <div class="paragraph">
  <p>for i in $(ls ./xls/*.csv | grep Basico)
  do
  lc=<code>echo $i | tr '[A-Z]' '[a-z]'</code>
  sed '1d' $i | sed 's/,/./g' &gt; $lc.csv
  done</p>
  </div>
  <div class="paragraph">
  <p>cat ./xls/basico*.csv.csv &gt; Basico.csv
  cat ./xls/domicilio01*.csv.csv &gt; Domicilio01.csv
  cat ./xls/domicilio02*.csv.csv &gt; Domicilio02.csv
  cat ./xls/domiciliorenda*.csv.csv &gt; DomicilioRenda.csv
  
negative.code:     <link href="//fonts.googleapis.com/css?family=Noto+Sans:300,400,700" rel="stylesheet" type="text/css">
      <link href="//fonts.googleapis.com/css?family=Noto+Serif:400,700,400italic" rel="stylesheet" type="text/css">
      <link href="//netdna.bootstrapcdn.com/font-awesome/4.0.3/css/font-awesome.css" rel="stylesheet">
      <link href="//arthurmolina.github.io/themes/saga/assets/css/style.css?v=1481746936210" rel="stylesheet" type="text/css">
      <link href="//arthurmolina.github.io/themes/saga/assets/css/animate.min.css?v=1481746936210" rel="stylesheet" type="text/css">
      <link href="https://arthurmolina.github.io/favicon.ico" rel="shortcut icon">
      <link rel="canonical" href="https://arthurmolina.github.io/2012-12-4-Jogando-o-Censo-2010-no-PostgreSQL.adoc" />
      <meta name="referrer" content="origin" />
  