[bikamonki]

Buggy, all I did is add Dean middle name to third line

  In:
  3, Roberto Carlos, soccer, Brazil
  35, Michael Jordan, baseball, USA
  6, James Dean Lebron, basketball, USA
  10, Shinji Kagawa, soccer, Japan

  Ex: Carlos is number 3 playing soccer

  Out:
  Carlos is number 3 playing soccer
  Jordan is number 35 playing baseball
  Dean is number 6 playing Lebron (what??)
  Kagawa is number 10 playing soccer

I guess you can't really solve the ambiguity of Carlos meaning the second word on the second column versus the last word of the second column; but the commas should at least hint a tabular pattern, no?