fork download
copy 
  1.  
  2. using System;
  3. using System.Text.RegularExpressions;
  4.  
  5. public class Test
  6. {
  7. public static void Main()
  8. {
  9. string strModifiedQuery  = @"SELECT TAB1.Key
  10. FROM TAB1 IN 'C:\TEST\SAMPLE\HELLO.mdb'
  11. ORDER BY TAB1.Key;";
  12. string result = Regex.Replace(strModifiedQuery, @"(?i)(?s)(.*?)\S+\s*\S+\s*'\w:\\\w+\\\w+\\(\w+)\.(?:mdb|accdb)'", "$1[$2].TAB1");
  13. Console.WriteLine(result);
  14. Console.ReadLine();
  15. }
  16. }
Success #stdin #stdout 0.08s 34176KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT TAB1.Key
FROM [HELLO].TAB1
ORDER BY TAB1.Key;
https://ideone.com/WYWVvy
language:
C# (gmcs 5.20.1)
created:
9 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!