in reply to Re^3: regex needed to remove parts of SQLin thread regex needed to remove parts of SQL
$sql =~ s/((?<=select)|(?<=,))\s*[^,]*?\s+as//gi ; [download]