Stan Nelson snelson82

## regexp_extract_string_from_parentheses.sql
-- Mixed with CASE, this will extract the float/digits in the last set of `()` in the string
CASE WHEN string_to_chop LIKE '%(%-%)%' THEN
  NULL
ELSE
  NULLIF (REPLACE(REPLACE(REGEXP_SUBSTR (string_to_chop, '\\([[:digit:]]+.[[:digit:]]+\\)$|\\([[:digit:]]+\\)$'), '(', ''), ')', ''), '')::float
END AS chopped_string

## move_all_subfolders_files_up_to_parent_folder.sh
find . -mindepth 2 -type f -print -exec mv {} . \;

## csv_progress_bar.rb
require 'progress_bar'

# Extends CSV class to include progress bar enhancement
class CSV
  module ProgressBar
    def progress_bar
      ::ProgressBar.new(@io.size, :bar, :counter, :percentage, :elapsed, :eta)
    end

    def each
	-- Mixed with CASE, this will extract the float/digits in the last set of `()` in the string
	CASE WHEN string_to_chop LIKE '%(%-%)%' THEN
	NULL
	ELSE
	NULLIF (REPLACE(REPLACE(REGEXP_SUBSTR (string_to_chop, '\\([[:digit:]]+.[[:digit:]]+\\)$\|\\([[:digit:]]+\\)$'), '(', ''), ')', ''), '')::float
	END AS chopped_string
	require 'progress_bar'

	# Extends CSV class to include progress bar enhancement
	class CSV
	module ProgressBar
	def progress_bar
	::ProgressBar.new(@io.size, :bar, :counter, :percentage, :elapsed, :eta)
	end

	def each