protected override string GetQueryStatement(string table, string column) { var trimPosition = trimType.ToString().ToUpperInvariant(); return($@" select trim({trimPosition} '{trimChars}' FROM {column}), count(*), count_noise(*) from {table} group by 1"); }
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"; }