Skip to content

Instantly share code, notes, and snippets.

View bferronato's full-sized avatar
🏠
Working from home

Bruno bferronato

🏠
Working from home
18 followers · 54 following
View GitHub Profile
@bferronato
bferronato / SELIC.gs
Created September 21, 2022 17:59 — forked from danperrout/SELIC.gs
API Função SELIC Google Planilhas (Sheets)
/*
* @return Retorna a taxa anual da SELIC de acordo com a data passada (se não for passada nenhuma data retorna a taxa anual do dia de hoje).
* Fonte: https://www.bcb.gov.br/estabilidadefinanceira/selicdadosdiarios
**/
function SELIC(dataConsulta = new Date()) {
var today = Utilities.formatDate(new Date(), "GMT+3", "dd/MM/yyyy");
if (dataConsulta.length == 0)
dataConsulta = new Date()
@bferronato
bferronato / exemplo-pratico-de-redux.markdown
Created January 19, 2021 03:11 — forked from mikansc/exemplo-pratico-de-redux.markdown
Exemplo prático de Redux
@bferronato
bferronato / index.html
Created November 6, 2020 16:37 — forked from leowebguy/index.html
Responsive iframe full screen. Display page without and hide original url address.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Test Layout</title>
<style type="text/css">
body, html
{
margin: 0; padding: 0; height: 100%; overflow: hidden;
}
@bferronato
bferronato / Code.gs
Created October 8, 2020 09:40 — forked from rheajt/Code.gs
examples of simple triggers with google apps script
/**
* These simple triggers are available in Sheets, Docs, and Forms
* Most of this information can be found:
* https://developers.google.com/apps-script/guides/triggers/events
*/
function onOpen(e) {
// {
// authMode: 'LIMITED',
// source: 'Spreadsheet' || 'Document' || 'Form',
// user: 'User'
@bferronato
bferronato / wget
Created August 21, 2020 17:43 — forked from ssaadh/wget
Wget examples
#Spider Websites with Wget – 20 Practical Examples
Wget is extremely powerful, but like with most other command line programs, the plethora of options it supports can be intimidating to new users. Thus what we have here are a collection of wget commands that you can use to accomplish common tasks from downloading single files to mirroring entire websites. It will help if you can read through the wget manual but for the busy souls, these commands are ready to execute.
1. Download a single file from the Internet
wget http://example.com/file.iso
2. Download a file but save it locally under a different name
wget ‐‐output-document=filename.html example.com
@bferronato
bferronato / Consultar IP externo de um endereço
Created August 23, 2017 18:06
### Para verificar o IP externo de um endereço
-- No prompt de comando do windows
nslookup codac00-as077.fiesc.com.br 8.8.8.8
@bferronato
bferronato / Excel converte data
Created July 12, 2017 19:08
Converter data no Excel do formato MM/DD/AAA para DD/MM/AAAA
Converter data no Excel do formato MM/DD/AAA para DD/MM/AAAA
=DATA(DIREITA(F42;4);ESQUERDA(F42;2);EXT.TEXTO(F42;4;2))
https://social.technet.microsoft.com/Forums/en-US/f7525b14-2039-41b5-8aa9-6ac63fbb8233/change-date-format-in-ms-excel-2013-form-mmddyyyy-to-ddmmyyyy?forum=excel
@bferronato
bferronato / MSSQL - Get sql View.sql
Created May 25, 2017 17:53
select cast(definition as varchar(4000))
from sys.objects o
join sys.sql_modules m on m.object_id = o.object_id
where o.object_id = object_id( 'dbo.V_NF_ENT_FORN_NOTA')
and o.type = 'V'
@bferronato
bferronato / formatar_data.php
Last active December 5, 2016 16:13
<?php
$show_date = DateTime::createFromFormat('d/m/Y', $dateInput)->format('Y-m-d');
// Fonte:
// http://stackoverflow.com/questions/15676344/format-date-dd-mm-yyyy-to-yyyy-mm-dd-php
@bferronato
bferronato / unifique.js
Last active November 19, 2016 11:49
/**
* Torna os elementos de um array unico, incrementando os que forem iguais
*/
Array.prototype.oneOfAKind = function() {
for(var i = 1; i < this.length; i++) {
if(this[i-1] >= this[i]) {
this[i] = this[i] + 1;
return this.oneOfAKind();