Search and Replace Help

hey guys!!!

I'm not much into RegX. so i need your help.

I've SQL Query and i need to find first two column names
from the the
query. Query could be in multiline or single line. it has to
have at
least one column name into the query and maximum 2 columns
.

Multiline:

SELECT [Id]
      ,[CompanyName]
      ,[LicenseKey_Id]
  FROM [Company]

Single line:

SELECT [Id],[CompanyName] FROM [Company]


after getting that column names, i need to replace them with
the user
defined column names.


guys, i would appreciate any help here. i'm in big trouble
as i dont
know how to use RegX.

Tools: VS2005, C#, .Net 2.0

Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "Regex" group.
To post to this group, send email to regexgooglegroups.com
To unsubscribe from this group, send email to
regex-unsubscribegooglegroups.com
For more options, visit this group at http://groups.go
ogle.com/group/regex
-~----------~----~----~----~------~----~------~--~---