public enum SanitizationMode
private static char Escape { get; } = '"';
private static char Quote { get; } = '"';
private static char Comma { get; } = ',';
private static char DataLinkEscape { get; } = (char)16;
private static string EscapeString { get; } = new string(new char[] { DataLinkEscape, Comma });
private static char[] InjectionCharacters { get; set; } = new[] { '=', '@', '+', '-', '|' };
private static char InjectionEscapeCharacter { get; } = '\'';
public static void Main()
Console.WriteLine(SanitizeString(temp, SanitizationMode.Remove));
public static string SanitizeString(string field, SanitizationMode sanitizationMode)
if (sanitizationMode != SanitizationMode.None)
if (string.IsNullOrEmpty(field))
if ((position = field.IndexOfAny(InjectionCharacters)) >= 0)
if (!string.IsNullOrWhiteSpace(field))
field = field.Replace(EscapeString, Comma.ToString());
private static bool IsNumeric(string inputData)
bool returnValue = false;
if (!(string.IsNullOrEmpty(inputData) || string.IsNullOrWhiteSpace(inputData)))
returnValue = decimal.TryParse(inputData, out tempValue);