Re:Show HN: Strans – Sed alternative that automatically lear...
by inventitech on Tuesday March 12, 2019 @07:46AM
(#19367215)
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.
Re:Show HN: Strans – Sed alternative that automatically lear...
by ygra on Tuesday March 12, 2019 @09:17AM
(#19367794)
Oh wow. I've learned about Excel's Flash Fill only recently and wasn't even aware that the same thing is available as a library as well.
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.
Re:Show HN: Strans – Sed alternative that automatically lear...
by inventitech on Tuesday March 12, 2019 @09:27AM
(#19367867)
Yup, perhaps that's why it's missing in the latest PowerShell release ...
https://docs.microsoft.com/en-us/powershell/module/Microsoft...
Re:Show HN: Strans – Sed alternative that automatically lear...
by apskim on Tuesday March 12, 2019 @02:44PM
(#19371573)
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
Re:Show HN: Strans – Sed alternative that automatically lear...
by inventitech on Wednesday March 13, 2019 @05:07AM
(#19376959)
Thanks for the explanation. And hi, Alex (cool to meet again here on HN)!
Would like to see more examples than First Middle Last.