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";
}
