Show HN: A tool that transforms your whole list with just one example • Hacker News Board

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

#21

Post by sixothree » Fri, Apr 24, 2015, 2:33 PM UTC

kylered wrote: 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.

I could have used this hundreds of time in Visual Studio.

We often process messages with hundreds of fields. So I will have a class from specs (usually excel) with a number of properties, then I need a method to populate each of those from some other object, then I need a method that does the reverse - populates some other object from the properties.

This happens over and over for us. Typically I just use a Notepad++ macro. But I could probably use this as it stands, just having it in visual studio would be really incredible.

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

#22

Post by thebouv » Fri, Apr 24, 2015, 2:33 PM UTC

chdir wrote: post #6

Any chance of making a plugin for Sublime Text?

That I could get behind. Often I have to use Sublime's regex find/replace to build my own data munging things that a plugin like this could solve.

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

#23

Post by zubairq » Fri, Apr 24, 2015, 2:35 PM UTC

In chrome it doesn't work. It never seems to update in real time, only at random long intervals

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

#24

Post by querious » Fri, Apr 24, 2015, 2:41 PM UTC

On a similar note: anyone know of a tool for generating SQL queries by example?

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

#25

Post by [deleted] » Fri, Apr 24, 2015, 2:41 PM UTC

BoppreH wrote: post #15

Amazing tool. Feature requests: allow for more than one example. Input: {"class": "101", "students": 101} {"class": "201", "students": 80} {"class": "202", "students": 50} {"class": "301", "students": 120} Example: Class 101 has 101 students Output: Class 101 has 101 students Class 201 has 201 students Class 202 has 202 students Class 301 has 301 students Right now the first line cannot have any ambiguity. This is fi…

[deleted]

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

#26

Post by sp332 » Fri, Apr 24, 2015, 2:41 PM UTC

thehoff wrote: post #9

createmyaccount wrote: post #2

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…

My brain doesn't understand what you're trying to do either. Why is Roberto/Carlos on every line?

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

#27

Post by crazygringo » Fri, Apr 24, 2015, 2:43 PM UTC

querious wrote: post #24

On a similar note: anyone know of a tool for generating SQL queries by example?

Both SQL queries and Regex expressions by example would be amazing.

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

#28

Post by [deleted] » Fri, Apr 24, 2015, 2:43 PM UTC

[deleted]

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

#29

Post by swalsh » Fri, Apr 24, 2015, 2:44 PM UTC

It would be cool if I could provide an xml file as input, and use the example to generate an xpath query quickly.

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

#30

Post by thehoff » Fri, Apr 24, 2015, 2:48 PM UTC

sp332 wrote: post #26

thehoff wrote: post #9

Earlier quoted context omitted.

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…

My brain doesn't understand what you're trying to do either. Why is Roberto/Carlos on every line?

I formatted their examples to appear like some real data I have that appears like this, obviously not names but descriptions of some projects. I was curious how this would handle it.

In any case, get rid of the "/" and its closer to real. Some people have more than two names in their full name. And on a set a little larger you could very well have something close to my second example.