Live data from Hacker News

Show HN: A tool that transforms your whole list with just one example

transformy.io

71–80 of 151 posts

Re: Show HN: A tool that transforms your whole list with just one example

#72

Amongst other things this can be used for cleaning tables/lists from special characters, changing date formats and creating xml or json. Feedback and suggestions are very much welcome! We plan on adding a few more features soon as right now it is fairly basic but would like to hear some opinions and see if there's people out there that have a use for this.

Does it work by a general library for learning patterns, or as a collection of heuristics to match common cases? That difference would change the kind of examples I would try it with, knowing in advance when they're too complex to work.

Currently there's no real machine learning or advanced pattern matching involved. But we're certainly working towards that!

Re: Show HN: A tool that transforms your whole list with just one example

#73
post #60

For some reason it won't handle certain characters... Input: Feature: 37, threshold: 4386, + Feature: 11, threshold: 1, + Feature: 10, threshold: 13, + Feature: 0, threshold: 34, + Feature: 39, threshold: 44, + Example: x[37] >= 4386 Output: x[37] 4386 x[11] 1 x[10] 13 x[0] 34 x[39] 44

Thanks for your feedback!

We'll fix this soon.

Re: Show HN: A tool that transforms your whole list with just one example

#74
post #18
post #4

I hope you sell your IP to Microsoft Excel. This would be a major time saver feature for a lot of the Excel world.

This is already in Excel as FlashFill, so don't know if you're being sarcastic. http://research.microsoft.com/en-us/um/people/sumitg/

Not sarcastic... I didn't know about FlashFill. I looked at the videos, and it seems that it's not as powerful as this tool. In excel the results would be a custom cell format combined with custom text functions.

Re: Show HN: A tool that transforms your whole list with just one example

#75
post #9

Amongst other things this can be used for cleaning tables/lists from special characters, changing date formats and creating xml or json. Feedback and suggestions are very much welcome! We plan on adding a few more features soon as right now it is fairly basic but would like to hear some opinions and see if there's people out there that have a use for this.

This is really neat! Any chance this will be a cli tool or module/library? It doesn't seem to play will with something like this as an input: 3, Roberto/Carlos, soccer, Brazil 35, Roberto/Carlos Michael Jordan, baseball, USA 6, Roberto/Carlos James Lebron, basketball, USA 10, Roberto/Carlos Shinji Kagawa, soccer, Japan Format: 3, ROBERTO/CARLOS, soccer, Brazil Gives me: 3, ROBERTO/CARLOS, soccer, Brazil 35, ROBERTO/C…

Given this "35, Roberto/Carlos Michael Jordan, baseball, USA" tuple what are you expecting as output?

Re: Show HN: A tool that transforms your whole list with just one example

#77

How is this done ? Do you need to use some fancy AI or machine learning algorithm ? Looks pretty mind blowing. Mad respect.

Thanks a lot!

It's pretty basic at the moment, but we'll be launching smarter and smarter versions as we go.

Re: Show HN: A tool that transforms your whole list with just one example

#80
post #74
post #18

Earlier quoted context omitted.

This is already in Excel as FlashFill, so don't know if you're being sarcastic. http://research.microsoft.com/en-us/um/people/sumitg/

Not sarcastic... I didn't know about FlashFill. I looked at the videos, and it seems that it's not as powerful as this tool. In excel the results would be a custom cell format combined with custom text functions.

Not sure about the implementation in Excel. At least the paper (POPL 2011) describes more powerful functions, containing e.g. case distinctions and simple loops. There are some examples in there. I'm not an Excel expert, but would be surprised if cell format could do that.
Post reply on HN