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

#1

Post by createmyaccount » Fri, Apr 24, 2015, 12:50 PM UTC

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

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

#2

Post by createmyaccount » Fri, Apr 24, 2015, 1:03 PM UTC

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.

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

#3

Post by habi » Fri, Apr 24, 2015, 2:00 PM UTC

Great use for quickly cleaning up stuff without looking into the `sed` options.

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

#4

Post by kylered » Fri, Apr 24, 2015, 2:02 PM UTC

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

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

#5

Post by hypoliet » Fri, Apr 24, 2015, 2:04 PM UTC

Sometimes, I have to use a bunch of numbers in an SQL query and surround them with single quotes and a comma. Seems a good fit, thanks.

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

#6

Post by chdir » Fri, Apr 24, 2015, 2:08 PM UTC

Any chance of making a plugin for Sublime Text?

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

#7

Post by jnbiche » Fri, Apr 24, 2015, 2:09 PM UTC

You know, for people that don't know Awk or aren't comfortable with a scripting language, this is a really nice idea. Thinking back to grad school, which was in a non-computer science quantitative field, there are lots of people that would have appreciated having something like this easily available.

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

#8

Post by sz4kerto » Fri, Apr 24, 2015, 2:09 PM UTC

For a second I thought this is some kind of a data mining/ML/search tool that could transform

USA, Barack

Germany, Angela

to

USA, Obama

Germany, Merkel

based on a single example. Do this please. :)

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

#9

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

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/CARLOS, Michael, Jordan
    6, ROBERTO/CARLOS, James, Lebron
    10, ROBERTO/CARLOS, Shinji, Kagawa

I can't seem to find a way to get it to parse that out properly (playing with the ROBERTO/CARLOS part.

I even tried 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 CARLOS, Michael, Jordan
    6, ROBERTO CARLOS, James, Lebron
    10, ROBERTO CARLOS, Shinji, Kagawa

Edit: format

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

#10

Post by FiReaNG3L » Fri, Apr 24, 2015, 2:11 PM UTC

"We're impoving transformy"

Start by improving your proofreading :)