vermorel

# Replace commas by dots in a very large file (full streaming)
$infile = ls .\MyFile.csv
$outfile = $infile.DirectoryName + "\MyFile.csv.out"
$reader = [System.IO.File]::OpenText($infile.FullName)
$writer = [System.IO.StreamWriter] $outfile
try {
  for(;;) {
    $line = $reader.ReadLine()
    if ($line -eq $null) { break }
    # process the line

vermorel

# Sample-Content
# By Joannes Vermorel, 2014
# Keep only 1 line out of N of a flat file
# Usage: sample-content .\myfile.csv 100

function Sample-Content()
{
  param
  (
    [string]$path = $null,

vermorel

// The CSV file produced by Relenta while exporting contact is somewhat messy.
// Using this tiny app to extract the first email address of each contact.

using System;
using System.IO;

namespace ConsoleTest
{
    class Program
    {

vermorel

# Measure-Loc
# By Joannes Vermorel, 2010
# Recurse directories and compute the number of C# lines
# Usage: measure-loc

function Measure-Loc
{

param(
)

vermorel

for /f "tokens=* delims=" %%i in ('dir /s /b /a:d *.svn') do (
rd /s /q "%%i"
)

vermorel

#----------------------------------------------------------------
# function Search-LokadWiki
# By Joannes Vermorel, Oct 2015, Lokad
#
# Print all the wiki page names that contains a specific string
# in their wiki code.
#----------------------------------------------------------------
function Search-LokadWiki()
{
    param

vermorel

# Cross-Join between two flat files
# By Joannes Vermorel, 2015-12-11
#
# Syntax:
# Crossjoin-Csv .\sample.csv .\sample.csv "Name" 

function Crossjoin-Csv
{
    param
    (

vermorel

using System;
using System.IO;
using System.IO.Compression;
using System.Text;

namespace Loader
{
    class FlatSampling
    {
        static void Main(string[] args)

vermorel

using System;
using System.Linq;
using System.Net;
using System.Security.Principal;
using System.Text;
using System.Web;
using System.Web.Mvc;

namespace ClientUI
{

vermorel

# Random expansion of monthly data into daily data
# Syntax: convert-daily "c:\LokadData\foo.tsv" 
# Expected columns are Id, Date, Quantity
# By Joannes Vermorel, April 2016

function convert-daily
{
    param
    (
        [string] $file