开发者

What elisp or macro magic can make this text transformation?

开发者 https://www.devze.com 2022-12-21 13:33 出处:网络
I have a set of SQL statements formatted like so: INSERT INTO reports.workload (workload_id,event_time,event_type_id,agent_id) VALUES

I have a set of SQL statements formatted like so:

INSERT INTO reports.workload (workload_id,event_time,event_type_id,agent_id) VALUES 
                             (-42000,'2010-02-23 07:30:38.941436',1,NULL);

Right now, the VALUES tuple is aligned at the start with the column name tuple. However, what I want is to have the tuple's elements aligned as well, like so:

INSERT INTO reports.workload (workload_id,event_time,                  event_type_id,agent_id) VALUES 
                             (-42000,开发者_StackOverflow中文版     '2010-02-23 07:30:38.941436',1            ,NULL);

My elisp-fu and regexp-fu are moderate, but not sufficient to this task. How can I do this?


Select the region you'd like to align, and type C-u C-x \ (that is a shortcut for align-regexp). Choose \(,\) as regex pattern and repeat it throughout line.

For more on text align, see chapter AlignCommands in EmacsWiki.

0

精彩评论

暂无评论...
验证码 换一张
取 消