fork download
  1. using System;
  2. using System.Collections.Generic;
  3. using System.IO;
  4. using System.Linq;
  5. using System.Text.RegularExpressions;
  6.  
  7. public class Test
  8. {
  9. public static void Main()
  10. {
  11. var text = "INSERT INTO TestTable\r\n(\r\n Test1,\r\n Test2,\r\n Test3,\r\n Test4,\r\n Test5\r\n)\r\nVALUES\r\n(\r\n @Test1,\r\n @Test2,\r\n\r\n @Test3,\r\n @Test4,\r\n\r\n @Test5\r\n)\r\n\r\nSET @Id = SCOPE_IDENTITY()";
  12. var result = Regex.Matches(text, @"\B@\w+\b(?!\s*=)")
  13. .Cast<Match>()
  14. .Select(x => x.Value);
  15. foreach (var s in result)
  16. Console.WriteLine(s);
  17. }
  18. }
Success #stdin #stdout 0.08s 21716KB
stdin
Standard input is empty
stdout
@Test1
@Test2
@Test3
@Test4
@Test5