[pbhjpbhj]

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

[thehoff]

I was expecting that as the output but got: 35, ROBERTO/CARLOS, Michael, Jordan

See other response as it works on word by word. Here is (hopefully) a better example:

Input:

    35, Billy Jean, soccer, USA
    29, Billy Jo Jean, football, USA

Transform-at:

    35, soccer, Billy Jean, USA

You'll get:

    35, soccer, Billy Jean, USA
    29, Jean, Billy Jo, football

But I was expecting:

    35, soccer, Billy Jean, USA
    29, football, Billy Jo Jean, USA

[pbhjpbhj]

Right, understand now, it's using words as atoms rather than breaking fields at the commas and using them.