fork download
copy 
  1. <?php
  2. $sql = 'SELECT
  3.     [Person].[Name]
  4.     [Person].[Address],
  5.     [Sales].[TotalAmount]';
  6.  
  7. preg_match_all('#\[[^]]+\]\.(\[[^]]+\])#', $sql, $found); // Match
  8. $max = max(array_map('strlen', $found[1])); // Find max length
  9.  
  10. $new = preg_replace_callback('#\[[^]]+\]\.(\[[^]]+\])#', function($m)use($max){
  11.     $string = $m[1].str_repeat(' ',$max - strlen($m[1])).' = '.$m[0];
  12. 	return($string);
  13. }, $sql);
  14. echo $new;
  15. ?>
Success #stdin #stdout 0.01s 20568KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT
    [Name]        = [Person].[Name]
    [Address]     = [Person].[Address],
    [TotalAmount] = [Sales].[TotalAmount]
https://ideone.com/pa4A3y
language:
PHP (php 7.3.5)
created:
11 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!