Example #1
0
        public TextColumnTrim(string tableName, string columnName, TextColumnTrimType trimType, string trimChars)
        {
            var trimPosition = trimType.ToString().ToUpperInvariant();

            QueryStatement = $@"
                select 
                    trim({trimPosition} '{trimChars}' FROM {columnName}),
                    count(*),
                    count_noise(*)
                from {tableName}
                group by 1";
        }
Example #2
0
 public TextColumnTrim(TextColumnTrimType trimType, string trimChars)
 {
     this.trimType  = trimType;
     this.trimChars = trimChars;
 }