I am not sure which implementation Excel uses under the hood -- Excel's flash fill feature has been there for quite some time; PROSE (which strans uses) has not, and Excel is not listed in its impact section. So this seems to hint at the fact that the engine Excel uses is different. Anyhow, the idea behind both definitely comes from the same team, and Sumit Gulwani in particular.
To clarify: Excel FlashFill uses an earlier version of this engine, with a similar but less advanced algorithm.
The current engine that powers strans (PROSE) can, for instance, solve the infamous "January" task without errors
Jan -> January, Feb -> February; Mar -> ...
Frequently used parts of language are often irregular. Fortunately, I don't think plaintext you'd use sed against is as irregular.
19 comments
[ 2.4 ms ] story [ 57.8 ms ] threadStrans – an alternative to sed that automatically learns from examples, instead of having to program yourself
Unfortunately, I can't change the title anymore
Strans – sed alternative that automatically learns a string-transformation from an example
Strans - auto text manipulation from sample input-output
sed without the obscure part
Would like to see more examples than First Middle Last.
PowerShell's Convert-String is very rough around the edges, though. Seems more like a proof of concept that ended up slipping into a release.
1. makes you laugh
2. blows your mind with its insight
3. is considered deeply relevant
I can't actually come up with it, but now that I have given you the description, please simulate the comment in your mind and give me credit for it.