Automating String Processing in Spreadsheets Using Input-Output Examples

被引:196
作者
Gulwani, Sumit [1 ]
机构
[1] Microsoft Res, Redmond, WA USA
关键词
Algorithms; Human Factors; Program Synthesis; User Intent; Programming by Example (PBE); Version Space Algebra; Spreadsheet Programming; String Manipulation;
D O I
10.1145/1925844.1926423
中图分类号
TP31 [计算机软件];
学科分类号
081205 [计算机软件];
摘要
We describe the design of a string programming/ expression language that supports restricted forms of regular expressions, conditionals and loops. The language is expressive enough to represent a wide variety of string manipulation tasks that end-users struggle with. We describe an algorithm based on several novel concepts for synthesizing a desired program in this language from input-output examples. The synthesis algorithm is very efficient taking a fraction of a second for various benchmark examples. The synthesis algorithm is interactive and has several desirable features: it can rank multiple solutions and has fast convergence, it can detect noise in the user input, and it supports an active interaction model wherein the user is prompted to provide outputs on inputs that may have multiple computational interpretations. The algorithm has been implemented as an interactive add-in for Microsoft Excel spreadsheet system. The prototype tool has met the golden test - it has synthesized part of itself, and has been used to solve problems beyond author's imagination.
引用
收藏
页码:317 / 329
页数:13
相关论文
共 23 条
[1]
LEARNING REGULAR SETS FROM QUERIES AND COUNTEREXAMPLES [J].
ANGLUIN, D .
INFORMATION AND COMPUTATION, 1987, 75 (02) :87-106
[2]
[Anonymous], 2008, CHI 2008 WORKSH US A
[3]
[Anonymous], POPL
[4]
[Anonymous], 2010, ARTIF INTELL
[5]
FISHER K, 2005, PLDI, P295
[6]
FISHER K, 2006, POPL, P2
[7]
FISHER K, 2008, POPL
[8]
Gualtieri M, 2019, DEPUTIZE END USER DE
[9]
Gulwani S, 2004, LECT NOTES COMPUT SC, V3148, P212
[10]
GULWANI S, 2010, PPDP ACM